Which Adelaide has an Auckland of yes, a Melbourne of yes, a Perth of yes, and a Sydney of cancelled?
CREATE TABLE table_name_39 (adelaide VARCHAR, sydney VARCHAR, perth VARCHAR, auckland VARCHAR, melbourne VARCHAR)
SELECT adelaide FROM table_name_39 WHERE auckland = "yes" AND melbourne = "yes" AND perth = "yes" AND sydney = "cancelled"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_39 (adelaide VARCHAR, sydney VARCHAR, perth VARCHAR, auckland VARCHAR, melbourne VARCHAR) Question: Which Adelaide has an Auckland of yes, a Melbourne of yes, a Perth of yes, and a Sydney of cancelled? [/INST] SELECT adelaide FROM table_name_39 WHERE auckland = "yes" AND melbourne = "yes" AND perth = "yes" AND sydney = "cancelled" </s>