WHAT NAME HAS A FREE TRANSFER FREE AND RETIRED?
CREATE TABLE table_name_74 (name VARCHAR, transfer_fee VARCHAR, moving_to VARCHAR)
SELECT name FROM table_name_74 WHERE transfer_fee = "free" AND moving_to = "retired"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (name VARCHAR, transfer_fee VARCHAR, moving_to VARCHAR) Question: WHAT NAME HAS A FREE TRANSFER FREE AND RETIRED? [/INST] SELECT name FROM table_name_74 WHERE transfer_fee = "free" AND moving_to = "retired" </s>