Give the order ids for all orders, as well as the total product quantity in each.
select order_id, sum(product_quantity) from order_items group by order_id