CREATE TABLE table_name_47 (sydney VARCHAR2, auckland VARCHAR2, melbourne VARCHAR2, gold_coast VARCHAR2, adelaide VARCHAR2)

Which Syndney's Gold coast, Adelaide, Melbourne, and Auckland were all no?
SELECT sydney FROM table_name_47 WHERE gold_coast = "no" AND adelaide = "no" AND melbourne = "no" AND auckland = "no"
SELECT "sydney" FROM "table_name_47" WHERE "adelaide" = "no" AND "auckland" = "no" AND "gold_coast" = "no" AND "melbourne" = "no"