Show the race class and number of races in each class.
CREATE TABLE race (CLASS VARCHAR)
SELECT CLASS, COUNT(*) FROM race GROUP BY CLASS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE race (CLASS VARCHAR) Question: Show the race class and number of races in each class. [/INST] SELECT CLASS, COUNT(*) FROM race GROUP BY CLASS </s>