human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Name, Country, Status, Transfer window, Transfer fee, Source
###Question: What was the transfer fee for the summer transfer involving the SCO named Crainey?
gpt
SELECT Transfer fee FROM table WHERE Transfer window = summer AND Country = sco AND Name = crainey