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

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'