牛客SQL学习 _必知必会_38_97 返回顾客名称和相关订单号以及每个订单的总价

---

一、题目

二、代码

select cu.cust_name,table1.order_num,table1.total_price
from Customers cu
join 
(
    select Orders.order_num, Orders.cust_id,(OrderItems.quantity * OrderItems.item_price ) as total_price
    from Orders 
    join OrderItems
    on Orders.order_num = OrderItems.order_num
) table1
on cu.cust_id = table1.cust_id
order by cu.cust_name,table1.order_num

三、运行结果