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