How many products were not included in any order?
SELECT count(*) FROM products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )
products not included in any order refers to product_id NOT IN (SELECT product_id FROM Order_items); count of such products is achieved using count(*);