Database: customers_and_invoices
Question: Count the number of products that were never ordered.
SQL:
SELECT count(*) FROM products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )