The finance team wants to compare the value of customers' paid orders with the quantities of products purchased in those orders.
The orders table stores each order's status and total amount (amount_usd). The order_items table stores individual products and their quantities (qty) within an order.
Prepare a customer-level summary showing the total value of paid orders and the total quantity of items in those paid orders. Orders of other statuses must not contribute to either total.
An order may contain several items, but its amount should contribute to the customer's revenue only once.
Ordering: Sort by customer_id in ascending order.