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

Question: What is the type where the country is esp?
SQL: SELECT "type" FROM players_20072008 WHERE "country" = 'ESP'

Question: What is the name where p is mf?
SQL: SELECT "name" FROM players_20072008 WHERE "p" = 'MF'

Question: What is the type where the name is bojan?
SQL: SELECT "type" FROM players_20072008 WHERE "name" = 'Bojan'