How many products were not included in any order?
CREATE TABLE products (product_id VARCHAR); CREATE TABLE Order_items (product_id VARCHAR)
SELECT COUNT(*) FROM products WHERE NOT product_id IN (SELECT product_id FROM Order_items)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE products (product_id VARCHAR); CREATE TABLE Order_items (product_id VARCHAR) Question: How many products were not included in any order? [/INST] SELECT COUNT(*) FROM products WHERE NOT product_id IN (SELECT product_id FROM Order_items) </s>