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