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

Which Adelaide has a Sydney of yes, a Perth of no, a Melbourne of yes, and an Auckland of no?
SELECT "Adelaide" FROM table_15348 WHERE "Sydney" = 'yes' AND "Perth" = 'no' AND "Melbourne" = 'yes' AND "Auckland" = 'no'
SELECT "Adelaide" FROM "table_15348" WHERE "Auckland" = 'no' AND "Melbourne" = 'yes' AND "Perth" = 'no' AND "Sydney" = 'yes'