Task: Text to Code
Input (English): How many students have each different allergy?
Output (English): SELECT Allergy ,  count(*) FROM Has_allergy GROUP BY Allergy