Table: solano
Columns: name
country
status
moving_to
transfer_fee

Question: Which country has Spence in the name section?
SQL: SELECT "country" FROM solano WHERE "name" = 'spence'

Question: Which country has the status of transferred, moving to of released, and Solano as the listed name?
SQL: SELECT "country" FROM solano WHERE "status" = 'transferred' AND "moving_to" = 'released' AND "name" = 'solano'

Question: What is the transfer fee for the country that has the name McCartney listed?
SQL: SELECT "transfer_fee" FROM solano WHERE "name" = 'mccartney'

Question: What is the name listed for the country that has a status of loaned and a moving to listed as leyton orient?
SQL: SELECT "name" FROM solano WHERE "status" = 'loaned' AND "moving_to" = 'leyton orient'

Question: What is the transfer fee for the country of Nir?
SQL: SELECT "transfer_fee" FROM solano WHERE "country" = 'nir'