How many players are from each country?
select country_name, count(*) from country as t1 join match_season as t2 on t1.country_id = t2.country group by t1.country_name