Show the order id for all order items.
select order_id from order_items
Also show the product id.
select order_id, product_id from order_items
For each order, show the number of products.
select order_id, count(distinct product_id) from order_items group by order_id