题解 | #返回顾客名称和相关订单号以及每个订单的总价#
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
select cust_name, o.order_num, sum(quantity * item_price) as OrderTotal
from Orders as o
left join OrderItems as oi
on o.order_num = oi.order_num
left join Customers as ct
on o.cust_id = ct.cust_id
group by cust_name,order_num
order by cust_name,order_num
from Orders as o
left join OrderItems as oi
on o.order_num = oi.order_num
left join Customers as ct
on o.cust_id = ct.cust_id
group by cust_name,order_num
order by cust_name,order_num
投递美的集团等公司6个岗位 >
海尔智家一面38人在聊