Database: e_commerce
Question: What is the number of products that have not been ordered yet?
SQL:
SELECT count(*) FROM Products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )