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

Which Melbourne has a Perth of yes, and an Auckland of yes?
SELECT "Melbourne" FROM table_15349 WHERE "Perth" = 'yes' AND "Auckland" = 'yes'
SELECT "Melbourne" FROM "table_15349" WHERE "Auckland" = 'yes' AND "Perth" = 'yes'