What Gold Coast has Auckland cancelled, and Adelaide yes?
CREATE TABLE "2012" (
  "auckland" text,
  "gold_coast" text,
  "sydney" text,
  "melbourne" text,
  "adelaide" text,
  "perth" text
);
SELECT "gold_coast" FROM "2012" WHERE "auckland"='cancelled' AND "adelaide"='yes';