yes or no for the auckland with a yes for sydney, no for perth, yes for melbourne and yes for the gold coast?
CREATE TABLE "1997" (
  "sydney" text,
  "melbourne" text,
  "perth" text,
  "adelaide" text,
  "gold_coast" text,
  "auckland" text
);
SELECT "auckland" FROM "1997" WHERE "sydney"='yes' AND "perth"='no' AND "melbourne"='yes' AND "gold_coast"='yes';