CREATE TABLE match_season (Country VARCHAR)
CREATE TABLE country (Country_name VARCHAR, Country_id VARCHAR)

Show the country names and the corresponding number of players.
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"