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

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'