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