How many customers have at least one order with status "Cancelled"?
CREATE TABLE customer_orders (customer_id VARCHAR, order_status VARCHAR)
SELECT COUNT(DISTINCT customer_id) FROM customer_orders WHERE order_status = "Cancelled"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE customer_orders (customer_id VARCHAR, order_status VARCHAR) Question: How many customers have at least one order with status "Cancelled"? [/INST] SELECT COUNT(DISTINCT customer_id) FROM customer_orders WHERE order_status = "Cancelled" </s>