Table schema:
CREATE TABLE table_name_74 (name VARCHAR, transfer_fee VARCHAR, moving_to VARCHAR)

Question: WHAT NAME HAS A FREE TRANSFER FREE AND RETIRED?
SQL: SELECT name FROM table_name_74 WHERE transfer_fee = "free" AND moving_to = "retired"