CREATE TABLE Order_items (product_id VARCHAR2, order_id VARCHAR2)

Show the product ids and the number of unique orders containing each product.
SELECT product_id, COUNT(DISTINCT order_id) FROM Order_items GROUP BY product_id
SELECT "product_id", COUNT(DISTINCT "order_id") FROM "Order_items" GROUP BY "product_id"