SELECT count(*) FROM products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )
How many products were not included in any order?
SELECT count ( * ) FROM products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )
select count ( * ) from products where product_id not in ( select product_id from order_items )
How many products were not included in any order ?