CREATE TABLE table_name_46 (transfer_fee VARCHAR, name VARCHAR)

What is the transfer fee for the country that has the name McCartney listed?
SELECT transfer_fee FROM table_name_46 WHERE name = "mccartney"
SELECT "transfer_fee" FROM "table_name_46" WHERE "mccartney" = "name"