CREATE TABLE table_name_39 (sydney VARCHAR2, auckland VARCHAR2, gold_coast VARCHAR2, adelaide VARCHAR2)

Which Sydney has Gold Coast no, Adelaide no< and Auckland no?
SELECT sydney FROM table_name_39 WHERE gold_coast = "no" AND adelaide = "no" AND auckland = "no"
SELECT "sydney" FROM "table_name_39" WHERE "adelaide" = "no" AND "auckland" = "no" AND "gold_coast" = "no"