How many stadiums does each country have?
CREATE TABLE stadium (country VARCHAR)
SELECT country, COUNT(*) FROM stadium GROUP BY country
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE stadium (country VARCHAR) Question: How many stadiums does each country have? [/INST] SELECT country, COUNT(*) FROM stadium GROUP BY country </s>