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