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

Which Adelaide has an Auckland of no and a Melbourne of no?
SELECT "Adelaide" FROM table_15345 WHERE "Auckland" = 'no' AND "Melbourne" = 'no'
SELECT "Adelaide" FROM "table_15345" WHERE "Auckland" = 'no' AND "Melbourne" = 'no'