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

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

https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250

select cust_name
, t1.order_num
, sum(quantity*item_price) OrderTotal
from Orders t1
left join Customers c on t1.cust_id = c.cust_id
left join OrderItems t2 on t1.order_num = t2.order_num
group by 1,2
order by 1,2

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务