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!