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

How many dates of vacancy were on 30 october 2010?
SELECT COUNT("Team") FROM table_29714 WHERE "Date of vacancy" = '30 October 2010'
SELECT COUNT("Team") FROM "table_29714" WHERE "Date of vacancy" = '30 October 2010'