Database: allergy_1
Question: Show all allergy types and the number of allergies in each type.
SQL:
SELECT allergytype ,  count(*) FROM Allergy_type GROUP BY allergytype