List the types of competition and the number of competitions of each type.
CREATE TABLE competition (Competition_type VARCHAR)
SELECT Competition_type, COUNT(*) FROM competition GROUP BY Competition_type
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE competition (Competition_type VARCHAR) Question: List the types of competition and the number of competitions of each type. [/INST] SELECT Competition_type, COUNT(*) FROM competition GROUP BY Competition_type </s>