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

Name the melbourne for adelaide of no with auckland of yes and gold coast of yes
SELECT "Melbourne" FROM table_67954 WHERE "Adelaide" = 'no' AND "Auckland" = 'yes' AND "Gold Coast" = 'no'
SELECT "Melbourne" FROM "table_67954" WHERE "Adelaide" = 'no' AND "Auckland" = 'yes' AND "Gold Coast" = 'no'