The finance team wants to compare item quantities and payment amounts for each paid order.
The orders table records order status, order_items records the products and quantities in an order, and payments records individual payment attempts.
Prepare one summary row for every order whose status is paid, showing its total item quantity and the sum of its recorded payment amounts. Include payments of all statuses, including captured and failed, in the payment total.
An order can have several items and several payments. Orders without items or payments should still appear, with 0 for the missing total.
Ordering: Sort by order_id in ascending order.