CREATE TABLE table_26976615_3 (date_of_appointment VARCHAR2, date_of_vacancy VARCHAR2)

How many date of appointments are there when the date of vacancy was 2 october 2010?
SELECT COUNT(date_of_appointment) FROM table_26976615_3 WHERE date_of_vacancy = "2 October 2010"
SELECT COUNT("date_of_appointment") FROM "table_26976615_3" WHERE "2 October 2010" = "date_of_vacancy"