Which Adelaide has an Auckland of yes, a Melbourne of yes, a Perth of yes, and a Sydney of cancelled?
CREATE TABLE "2008" (
  "sydney" text,
  "melbourne" text,
  "perth" text,
  "adelaide" text,
  "gold_coast" text,
  "auckland" text
);
SELECT "adelaide" FROM "2008" WHERE "auckland"='yes' AND "melbourne"='yes' AND "perth"='yes' AND "sydney"='cancelled';