Name the melbourne with perth, adelaide and auckland of no with sydney of yes
CREATE TABLE "2007" (
  "sydney" text,
  "melbourne" text,
  "perth" text,
  "adelaide" text,
  "gold_coast" text,
  "auckland" text
);
SELECT "melbourne" FROM "2007" WHERE "perth"='no' AND "adelaide"='no' AND "auckland"='no' AND "sydney"='yes';