Show all allergy types and the number of allergies in each type.
CREATE TABLE Allergy_type (allergytype VARCHAR)
SELECT allergytype, COUNT(*) FROM Allergy_type GROUP BY allergytype
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Allergy_type (allergytype VARCHAR) Question: Show all allergy types and the number of allergies in each type. [/INST] SELECT allergytype, COUNT(*) FROM Allergy_type GROUP BY allergytype </s>