question: WHAT NAME HAS A FREE TRANSFER FREE AND RETIRED?
answer: SELECT name FROM table_name_74 WHERE transfer_fee = "free" AND moving_to = "retired"
context: CREATE TABLE table_name_74 (name VARCHAR, transfer_fee VARCHAR, moving_to VARCHAR)