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