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

select t1.cust_name,t2.order_num,sum(t3.quantity*t3.item_price) OrderTotal
from Customers t1,Orders t2,OrderItems t3
where t1.cust_id=t2.cust_id and t2.order_num=t3.order_num
group by t1.cust_name,t2.order_num
order by t1.cust_name