human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Sydney, Melbourne, Perth, Adelaide, Gold Coast, Auckland
###Question: What is The Melbourne with a No- Gold Coast
gpt
SELECT Melbourne FROM table WHERE Gold Coast = no