CREATE TABLE Allergy_type (allergytype VARCHAR)

Show all allergy types and the number of allergies in each type.
SELECT allergytype, COUNT(*) FROM Allergy_type GROUP BY allergytype
SELECT "allergytype", COUNT(*) FROM "Allergy_type" GROUP BY "allergytype"