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

select a.cust_name,b.order_num,sum(quantity*item_price)OrderTotal
from Orders b
right join Customers  a
on a.cust_id = b.cust_id
right join OrderItems c
on b.order_num = c.order_num
group by cust_name,order_num
order by cust_name,order_num