Show the order id for each order item.
select order_id from order_items
For each of those items, also show the product quantities.
select order_id, product_quantity from order_items
For each order, what is the total quantity?
select order_id, sum(product_quantity) from order_items group by order_id