Which Gold Coast has a Perth of no, a Sydney of yes, and an Auckland of yes?
CREATE TABLE "2008" (
  "sydney" text,
  "melbourne" text,
  "perth" text,
  "adelaide" text,
  "gold_coast" text,
  "auckland" text
);
SELECT "gold_coast" FROM "2008" WHERE "perth"='no' AND "sydney"='yes' AND "auckland"='yes';