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

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'