How many date of appointments are there when the date of vacancy was 2 october 2010?
CREATE TABLE "managerial_changes" (
  "team" text,
  "outgoing_manager" text,
  "manner_of_departure" text,
  "date_of_vacancy" text,
  "incoming_manager" text,
  "date_of_appointment" text
);
SELECT COUNT("date_of_appointment") FROM "managerial_changes" WHERE "date_of_vacancy"='2 October 2010';