CREATE TABLE table_name_54 (player VARCHAR, country VARCHAR)

Who is the golfer that golfs for Northern Ireland?
SELECT player FROM table_name_54 WHERE country = "northern ireland"
SELECT "player" FROM "table_name_54" WHERE "country" = "northern ireland"