What are all the different allergies?
select distinct allergy from has_allergy
How many students does each of them affect?
select allergy, count(*) from has_allergy group by allergy