题解 | #返回顾客名称和相关订单号以及每个订单的总价#
返回顾客名称和相关订单号以及每个订单的总价
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
腾讯云智研发公司福利 128人发布
投递虾皮信息等公司7个岗位 >
