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