题解 | #返回顾客名称和相关订单号以及每个订单的总价#
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
select c.cust_name,os.order_num,sum(os.quantity*os.item_price) OrderTotal from Orders o inner join OrderItems os on os.order_num=o.order_num #只需要显示三张表的交集，所以不用左联 inner join Customers c on c.cust_id=o.cust_id group by c.cust_name,os.order_num order by c.cust_name,os.order_num
投递智联招聘等公司6个岗位
