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

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"