List the players and their country names.
select t2.player,t1.country_name from country as t1 join match_season as t2 on t1.country_id = t2.country where t2.position = "Defender"
Which ones have the position of Forward?
select t2.player,t1.country_name from country as t1 join match_season as t2 on t1.country_id = t2.country where t2.position = "Defender" where t2.position = "Forward"
What about the official languages of them?
select t1.official_native_language from country as t1 join match_season as t2 on t1.country_id = t2.country where t2.position = "Defender"
How many official languages in total for the defenders?
select count(distinct t1.official_native_language) from country as t1 join match_season as t2 on t1.country_id = t2.country where t2.position = "Defender"