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

Show the season, the player, and the name of the country that player belongs to.
SELECT T2.Season, T2.Player, T1.Country_name FROM country AS T1 JOIN match_season AS T2 ON T1.Country_id = T2.Country
SELECT "T2"."Season", "T2"."Player", "T1"."Country_name" FROM "country" "T1" JOIN "match_season" "T2" ON "T1"."Country_id" = "T2"."Country"