题解 | #返回顾客名称和相关订单号以及每个订单的总价#

select C.cust_name,O.order_num,sum(OI.quantity * OI.item_price) OrderTotal from Customers C join Orders O on C.cust_id =O.cust_id join OrderItems OI on O.order_num = OI.order_num group by C.cust_name,O.order_num order by C.cust_name asc,O.order_num asc