What is the date of appointment for the date of vacancy of 22 august 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 "date_of_appointment" FROM "managerial_changes" WHERE "date_of_vacancy"='22 August 2010';