Show all allergy types and the number of allergies in each type.
create table allergy_type (allergytype varchar, PRIMARY KEY (allergytype))
select allergytype, count(*) from allergy_type group by allergytype