What is the transfer fee for the country that has the name McCartney listed?
CREATE TABLE table_name_46 (transfer_fee VARCHAR, name VARCHAR)
SELECT transfer_fee FROM table_name_46 WHERE name = "mccartney"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (transfer_fee VARCHAR, name VARCHAR) Question: What is the transfer fee for the country that has the name McCartney listed? [/INST] SELECT transfer_fee FROM table_name_46 WHERE name = "mccartney" </s>