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