CREATE TABLE table_name_75 (date_of_vacancy VARCHAR, manner_of_departure VARCHAR, date_of_appointment VARCHAR)

What is the vacancy date for the manager appointed on 2 November 2009 who left due to mutual consent?
SELECT date_of_vacancy FROM table_name_75 WHERE manner_of_departure = "mutual consent" AND date_of_appointment = "2 november 2009"
SELECT "date_of_vacancy" FROM "table_name_75" WHERE "2 november 2009" = "date_of_appointment" AND "manner_of_departure" = "mutual consent"