Table schema:
CREATE TABLE table_name_73 (replaced_by VARCHAR, date_of_appointment VARCHAR)

Question: I want the replaced for date of appointment being 12 october 2007
SQL: SELECT replaced_by FROM table_name_73 WHERE date_of_appointment = "12 october 2007"