Which Adelaide's Melbourne, Sydney, and Gold Coast were all no?
CREATE TABLE table_name_30 (adelaide VARCHAR, gold_coast VARCHAR, melbourne VARCHAR, sydney VARCHAR)
SELECT adelaide FROM table_name_30 WHERE melbourne = "no" AND sydney = "no" AND gold_coast = "no"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (adelaide VARCHAR, gold_coast VARCHAR, melbourne VARCHAR, sydney VARCHAR) Question: Which Adelaide's Melbourne, Sydney, and Gold Coast were all no? [/INST] SELECT adelaide FROM table_name_30 WHERE melbourne = "no" AND sydney = "no" AND gold_coast = "no" </s>