CREATE TABLE table_name_46 (transfer_fee VARCHAR(255), name VARCHAR(255))
What is the transfer fee for the country that has the name McCartney listed?
    
SQL: SELECT transfer_fee FROM table_name_46 WHERE name = "mccartney"