When Bubbles of no, and a Category of miscellaneous, and a Type of propertychange, what was the Cancelable?
CREATE TABLE table_name_97 (cancelable VARCHAR, type VARCHAR, bubbles VARCHAR, category VARCHAR)
SELECT cancelable FROM table_name_97 WHERE bubbles = "no" AND category = "miscellaneous" AND type = "propertychange"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (cancelable VARCHAR, type VARCHAR, bubbles VARCHAR, category VARCHAR) Question: When Bubbles of no, and a Category of miscellaneous, and a Type of propertychange, what was the Cancelable? [/INST] SELECT cancelable FROM table_name_97 WHERE bubbles = "no" AND category = "miscellaneous" AND type = "propertychange" </s>