Which player is from Northern Ireland?
CREATE TABLE table_name_42 (player VARCHAR, country VARCHAR)
SELECT player FROM table_name_42 WHERE country = "northern ireland"
### Context: CREATE TABLE table_name_42 (player VARCHAR, country VARCHAR) ### Question: Which player is from Northern Ireland? ### Answer: SELECT player FROM table_name_42 WHERE country = "northern ireland"