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

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" "T1" JOIN "match_season" "T2" ON "T1"."Country_id" = "T2"."Country" GROUP BY "T1"."Country_name"