What is the transfer window in esp with promoted type and more than 2010 ends?
CREATE TABLE table_name_85 (transfer_window VARCHAR, ends VARCHAR, country VARCHAR, type VARCHAR)
SELECT transfer_window FROM table_name_85 WHERE country = "esp" AND type = "promoted" AND ends > 2010
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_85 (transfer_window VARCHAR, ends VARCHAR, country VARCHAR, type VARCHAR) Question: What is the transfer window in esp with promoted type and more than 2010 ends? [/INST] SELECT transfer_window FROM table_name_85 WHERE country = "esp" AND type = "promoted" AND ends > 2010 </s>