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

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