CREATE TABLE table_29171 ("Team" CLOB, "Outgoing manager" CLOB, "Manner of departure" CLOB, "Date of vacancy" CLOB, "Incoming manager" CLOB, "Date of appointment" CLOB)

How many date of appointments are there when the date of vacancy was 2 october 2010?
SELECT COUNT("Date of appointment") FROM table_29171 WHERE "Date of vacancy" = '2 October 2010'
SELECT COUNT("Date of appointment") FROM "table_29171" WHERE "Date of vacancy" = '2 October 2010'