Complete a sales report · WITH

Intermediate result · WITH · totals From Orders(orders), show Customer ID(orders.customer_id) → sum ((Quantity(order_items.quantity) * Unit price at order (KRW)(order_items.unit_price))) [result column name: total] in this order. Connect the data using INNER JOIN · Order items(order_items). Match rows when ID(orders.id) = Order ID(order_items.order_id). Keep only rows where Order status(orders.status) = 'Paid'. Group rows with the same Customer ID(orders.customer_id). Final query From Customers(customers), show Name(customers.name) → totals.total in this order. Connect the data using INNER JOIN · totals. Match rows when ID(customers.id) = totals.customer_id. Finally, sort by totals.total · descending (largest first) → ID(customers.id) · ascending (smallest first).