SELECT count(*) ,  country_code FROM players GROUP BY country_code
How many players are from each country?
SELECT count ( * ) , country_code FROM players GROUP BY country_code
select count ( * ) , country_code from players group by country_code
How many players are from each country ?