CREATE TABLE table_name_24 (player VARCHAR2, country VARCHAR2)

Which player is from scotland?
SELECT player FROM table_name_24 WHERE country = "scotland"
SELECT "player" FROM "table_name_24" WHERE "country" = "scotland"