CREATE TABLE Has_allergy (Allergy VARCHAR)

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