What is the last match with a resigned manner of departure and a round 1 date of vacancy?
CREATE TABLE "managerial_changes" (
  "team" text,
  "outgoing_manager" text,
  "manner_of_departure" text,
  "date_of_vacancy" text,
  "last_match" text,
  "replaced_by" text
);
SELECT "last_match" FROM "managerial_changes" WHERE "manner_of_departure"='resigned' AND "date_of_vacancy"='round 1';