What are the different allergy types?
select distinct allergytype from allergy_type
For each, how many students does it affect?
select t2.allergytype, count(*) from has_allergy as t1 join allergy_type as t2 on t1.allergy = t2.allergy group by t2.allergytype