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

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'