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

Which Sydney has a Gold Coast of yes, an Adelaide of no, and an Auckland of yes?
SELECT "Sydney" FROM table_15346 WHERE "Gold Coast" = 'yes' AND "Adelaide" = 'no' AND "Auckland" = 'yes'
SELECT "Sydney" FROM "table_15346" WHERE "Adelaide" = 'no' AND "Auckland" = 'yes' AND "Gold Coast" = 'yes'