What is the result for Melbourne when Adelaide, Sydney, and Perth are yes, and Gold Coast is no?
CREATE TABLE "1995" (
  "sydney" text,
  "melbourne" text,
  "perth" text,
  "adelaide" text,
  "gold_coast" text,
  "auckland" text
);
SELECT "melbourne" FROM "1995" WHERE "adelaide"='yes' AND "sydney"='yes' AND "perth"='yes' AND "gold_coast"='no';