SELECT country ,  count(*) FROM stadium GROUP BY country
How many stadiums does each country have?
SELECT country , count ( * ) FROM stadium GROUP BY country
select country , count ( * ) from stadium group by country
How many stadiums does each country have ?