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)
### Context: CREATE TABLE products (product_id VARCHAR); CREATE TABLE Order_items (product_id VARCHAR) ### Question: How many products were not included in any order? ### Answer: SELECT COUNT(*) FROM products WHERE NOT product_id IN (SELECT product_id FROM Order_items)