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

### Instruction:
Name the melbourne for adelaide of no with auckland of yes and gold coast of yes

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

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