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 be like?  Can the steps be completed in one run or should they be separated into several steps?

Thanks!