What are the allergy types and how many allergies correspond to each one?
SELECT allergytype ,  count(*) FROM Allergy_type GROUP BY allergytype
allergy types refers to allergytype; how many allergies correspond to each one refers to COUNT(allergytype);