user: ### NOW ANSWER:
Question: Name the sydney with perth of No, adelaide of No with melbourne of Yes and gold coast of Yes
Columns: ['Sydney', 'Melbourne', 'Perth', 'Adelaide', 'Gold Coast', 'Auckland']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes *']
SQL:

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