Yes, sorry that I didn't make it clear. I meant the corresponding name and ID of the country for Dublin as capital, in the "country" table.
select country_name, country_id from country where capital = "Dublin"
Thank you. Then could you please show me the positions of players from Ireland? So country ID 4
select position from match_season where country = 4
Great, thank you. What about their names?
select player from match_season where country = 4
yes, the 'player' field, so names.
select t1.player from match_season as t1 join country as t2 on t1.country = t2.country_id where t2.country_name = "Iraq"