Show all allergies with number of students affected.
CREATE TABLE Has_allergy (Allergy VARCHAR)
SELECT Allergy, COUNT(*) FROM Has_allergy GROUP BY Allergy
### Context: CREATE TABLE Has_allergy (Allergy VARCHAR) ### Question: Show all allergies with number of students affected. ### Answer: SELECT Allergy, COUNT(*) FROM Has_allergy GROUP BY Allergy