Total Items per Order

Problem

Amazon warehouses route orders to different packing stations based on size. For instance, an order with 20 items might get a big box; whereas an order with two items might go in an envelope. Using the order_items table, return order_id and total_items (the sum of all quantities in that order), ordered by order_id.

Schema

order_items

Sample Data

Expected Output