Schema: CREATE TABLE table_name_24 (player VARCHAR, country VARCHAR)
Question: Which player is from scotland?
SQL: SELECT player FROM table_name_24 WHERE country = "scotland"