SELECT Country_name ,  COUNT(*) FROM country AS T1 JOIN match_season AS T2 ON T1.Country_id  =  T2.Country GROUP BY T1.Country_name
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
select country_name , count ( * ) from country as t1 join match_season as t2 on t1 . country_id = t2 . country group by t1 . country_name
How many players are from each country ?