What are the different allergy types?
select distinct allergytype from allergy_type
How many are in each category?
select allergytype, count(*) from allergy_type group by allergytype