Which Perth has Gold Coast yes, Sydney yes, Melbourne yes, and Adelaide yes?
CREATE TABLE table_name_56 (
    perth VARCHAR,
    adelaide VARCHAR,
    melbourne VARCHAR,
    gold_coast VARCHAR,
    sydney VARCHAR
)
SELECT perth FROM table_name_56 WHERE gold_coast = "yes" AND sydney = "yes" AND melbourne = "yes" AND adelaide = "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: Which Perth has Gold Coast yes, Sydney yes, Melbourne yes, and Adelaide yes? ### Input: CREATE TABLE table_name_56 (
    perth VARCHAR,
    adelaide VARCHAR,
    melbourne VARCHAR,
    gold_coast VARCHAR,
    sydney VARCHAR
) ### Response: SELECT perth FROM table_name_56 WHERE gold_coast = "yes" AND sydney = "yes" AND melbourne = "yes" AND adelaide = "yes"