How many stadiums does each country have?
CREATE TABLE stadium (country VARCHAR)
SELECT country, COUNT(*) FROM stadium GROUP BY country
### Context: CREATE TABLE stadium (country VARCHAR) ### Question: How many stadiums does each country have? ### Answer: SELECT country, COUNT(*) FROM stadium GROUP BY country