CREATE TABLE table_67836 ("Sydney" TEXT, "Melbourne" TEXT, "Perth" TEXT, "Adelaide" TEXT, "Gold Coast" TEXT, "Auckland" TEXT)

yes or no for the melbourne with yes for gold coast, yes for adelaide, no for auckland?
SELECT "Melbourne" FROM table_67836 WHERE "Gold Coast" = 'yes' AND "Adelaide" = 'no' AND "Auckland" = 'no'
SELECT "Melbourne" FROM "table_67836" WHERE "Adelaide" = 'no' AND "Auckland" = 'no' AND "Gold Coast" = 'yes'