How many students have each different allergy?
select allergy, count(*) from has_allergy group by allergy