yes or no for the gold coast with yes for melbourne, yes for adelaide, yes for auckland?
CREATE TABLE table_name_2 (
    gold_coast VARCHAR,
    auckland VARCHAR,
    melbourne VARCHAR,
    adelaide VARCHAR
)
SELECT gold_coast FROM table_name_2 WHERE melbourne = "yes" AND adelaide = "yes" AND auckland = "yes"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: yes or no for the gold coast with yes for melbourne, yes for adelaide, yes for auckland? ### Input: CREATE TABLE table_name_2 (
    gold_coast VARCHAR,
    auckland VARCHAR,
    melbourne VARCHAR,
    adelaide VARCHAR
) ### Response: SELECT gold_coast FROM table_name_2 WHERE melbourne = "yes" AND adelaide = "yes" AND auckland = "yes"