user: ### NOW ANSWER:
Question: Which Gold Coast has Auckland No, Adelaide Yes, and Melbourne No?
Columns: ['Auckland', 'Gold Coast', 'Sydney', 'Melbourne', 'Adelaide', 'Perth']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Cancelled', 'Yes', 'Yes', 'Yes', 'Cancelled', 'Cancelled']
SQL:

assistant: SELECT "Gold Coast" FROM "Table" WHERE "Auckland" = 'No' AND "Adelaide" = 'Yes' AND "Melbourne" = 'No';