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

What is The Melbourne with a No- Gold Coast
SELECT "Melbourne" FROM table_79822 WHERE "Gold Coast" = 'no'
SELECT "Melbourne" FROM "table_79822" WHERE "Gold Coast" = 'no'