Table: player_data
Columns: name
country
status
transfer_window
transfer_fee
source

Question: What is the person's name that is from the country of SCO?
SQL: SELECT "name" FROM player_data WHERE "country" = 'sco'

Question: What was the source for the person named Cresswell?
SQL: SELECT "source" FROM player_data WHERE "name" = 'cresswell'

Question: What is the current status of the person named Nicholls?
SQL: SELECT "status" FROM player_data WHERE "name" = 'nicholls'

Question: What was the transfer fee for the summer transfer involving the SCO named Crainey?
SQL: SELECT "transfer_fee" FROM player_data WHERE "transfer_window" = 'summer' AND "country" = 'sco' AND "name" = 'crainey'

Question: What was the source of an ENG transfer that paid a £1.5m transfer fee?
SQL: SELECT "source" FROM player_data WHERE "country" = 'eng' AND "transfer_fee" = '£1.5m'