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

Which Melbourne has an Auckland of no, and a Gold Coast of no?
SELECT "Melbourne" FROM table_68015 WHERE "Auckland" = 'no' AND "Gold Coast" = 'no'
SELECT "Melbourne" FROM "table_68015" WHERE "Auckland" = 'no' AND "Gold Coast" = 'no'