How many order items correspond to each order id?
select order_id, count(*) from order_items group by order_id