Below is an instruction that describes a task. Write a response that appropriately completes the request.

### Instruction:
What is the result for Melbourne when Adelaide, Sydney, and Perth are yes, and Gold Coast is no?

### Inputs:
table_name: table, columns: ['Sydney', 'Melbourne', 'Perth', 'Adelaide', 'Gold Coast', 'Auckland']

### Response:
SELECT Melbourne FROM table WHERE Adelaide = yes AND Sydney = yes AND Perth = yes AND Gold Coast = no