Database: e_commerce
Question: How many kinds of products have not been sold?
SQL:
SELECT count(*) FROM Products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )