Table schema:
CREATE TABLE stadium (country VARCHAR)

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