Task: Text to Code
Input (English): How many students are affected by cat allergies?
Output (English): SELECT count(*) FROM Has_allergy WHERE Allergy  =  "Cat"