Pls see the example below:
Let's start with a table called "Pets"
Job:
1. Create a new table (call it NewPets)
2. One column equals Max(Food), whereas Food was a column in Pets that registered how much (say, grams) each meal contains
3. Add one column (FoodStats) in NewPets whereas:
if Max(Food)<1, FoodStats="NIL"
if 1=<Max(Food)<=10, FoodStats="LITTLE"
if 11<=Max(Food) <=50, FoodStats="SOME"
and so on....
What should the SQL like? I know part of the code (step 1) but have trouble with the rest.
Thanks a lot!