Show the match season and the corresponding country.
select t2.season, t1.country_name from country as t1 join match_season as t2 on t1.country_id = t2.country
How many distinct countries in total?
select count(distinct t1.country_name) from country as t1 join match_season as t2 on t1.country_id = t2.country
List the player names who are from Ireland.
select t2.player from country as t1 join match_season as t2 on t1.country_id = t2.country where t1.country_name = "Ireland"
How about Indonesia?
select t2.player from country as t1 join match_season as t2 on t1.country_id = t2.country where t1.country_name = "Indonesia"