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

Which Gold Coast has Melbourne yes, and Auckland yes?
SELECT "Gold Coast" FROM table_70889 WHERE "Melbourne" = 'yes' AND "Auckland" = 'yes'
SELECT "Gold Coast" FROM "table_70889" WHERE "Auckland" = 'yes' AND "Melbourne" = 'yes'