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

Which Gold Coast has Auckland no, Adelaide yes, and Melbourne no?
SELECT "Gold Coast" FROM table_70891 WHERE "Auckland" = 'no' AND "Adelaide" = 'yes' AND "Melbourne" = 'no'
SELECT "Gold Coast" FROM "table_70891" WHERE "Adelaide" = 'yes' AND "Auckland" = 'no' AND "Melbourne" = 'no'