CREATE TABLE table_name_43 (sydney VARCHAR2, gold_coast VARCHAR2, auckland VARCHAR2, melbourne VARCHAR2, perth VARCHAR2)

yes or no for the sydney with yes for melbourne, no for perth, no for auckland and no for gold coast?
SELECT sydney FROM table_name_43 WHERE melbourne = "yes" AND perth = "no" AND auckland = "no" AND gold_coast = "no"
SELECT "sydney" FROM "table_name_43" WHERE "auckland" = "no" AND "gold_coast" = "no" AND "melbourne" = "yes" AND "no" = "perth"