Count the number of products that were never ordered.
SELECT count(*) FROM products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )
products that were never ordered refers to products not present in order table; count the number refers to COUNT(*) function;