Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_75 ( date_of_vacancy VARCHAR, manner_of_departure VARCHAR, date_of_appointment VARCHAR )

### Question ###
What is the vacancy date for the manager appointed on 2 November 2009 who left due to mutual consent?

### Accurate SQL ###

SELECT date_of_vacancy FROM table_name_75 WHERE manner_of_departure = "mutual consent" AND date_of_appointment = "2 november 2009"