SCHEMA:
CREATE TABLE table_name_24 (player VARCHAR, country VARCHAR)
USER:
Which player is from scotland?

QUERY:
SELECT player FROM table_name_24 WHERE country = "scotland"