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_26976615_3 ( date_of_appointment VARCHAR, date_of_vacancy VARCHAR )

### Question ###
How many date of appointments are there when the date of vacancy was 2 october 2010?

### Accurate SQL ###

SELECT COUNT(date_of_appointment) FROM table_26976615_3 WHERE date_of_vacancy = "2 October 2010"