Which Perth's gold coast and Adelaide were yes when Auckland was no?
CREATE TABLE "1994" (
  "sydney" text,
  "melbourne" text,
  "perth" text,
  "adelaide" text,
  "gold_coast" text,
  "auckland" text
);
SELECT "perth" FROM "1994" WHERE "gold_coast"='yes' AND "adelaide"='yes' AND "auckland"='no';