Table schema:
CREATE TABLE Has_allergy (Allergy VARCHAR)

Question: Show all allergies with number of students affected.
SQL: SELECT Allergy, COUNT(*) FROM Has_allergy GROUP BY Allergy