Show the order id for each order item.
select order_id from order_items
For each of those ids, how many items were ordered?
select order_id, count(*) from order_items group by order_id