Table schema:
CREATE TABLE table_name_42 (player VARCHAR, country VARCHAR)

Question: Which player is from Northern Ireland?
SQL: SELECT player FROM table_name_42 WHERE country = "northern ireland"