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

yes or no for the melbourne that has no for adelaide, no for gold coast?
SELECT "Melbourne" FROM table_67838 WHERE "Adelaide" = 'yes' AND "Gold Coast" = 'no'
SELECT "Melbourne" FROM "table_67838" WHERE "Adelaide" = 'yes' AND "Gold Coast" = 'no'