CREATE TABLE table_67950 ("Sydney" CLOB, "Melbourne" CLOB, "Perth" CLOB, "Adelaide" CLOB, "Gold Coast" CLOB, "Auckland" CLOB)

Name the melbourne with perth, adelaide and auckland of no with sydney of yes
SELECT "Melbourne" FROM table_67950 WHERE "Perth" = 'no' AND "Adelaide" = 'no' AND "Auckland" = 'no' AND "Sydney" = 'yes'
SELECT "Melbourne" FROM "table_67950" WHERE "Adelaide" = 'no' AND "Auckland" = 'no' AND "Perth" = 'no' AND "Sydney" = 'yes'