Table: player_transfers
Columns: n
p
name
eu
country
age
type
moving_from
transfer_window
ends
transfer_fee
source

Question: What is the type of the player whose transfer fee was €20m?
SQL: SELECT "type" FROM player_transfers WHERE "transfer_fee" = '€20M'

Question: What is the EU status of ESP?
SQL: SELECT "eu" FROM player_transfers WHERE "country" = 'ESP'

Question: How many numbers are ending in 1 year?
SQL: SELECT COUNT("n") FROM player_transfers WHERE "ends" = '1 year'