SELECT Allergy ,  count(*) FROM Has_allergy GROUP BY Allergy
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
Show all allergies with number of students affected .