题解 | #确定最佳顾客的另一种方式(二)#

确定最佳顾客的另一种方式(二)

https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa

select cust_name,total_price
from 
(select
    order_num,
    sum(item_price * quantity) as total_price
from
    OrderItems
group by
    order_num
having total_price>=1000) as s1 inner join 
(select order_num,cust_name from Orders as o inner join Customers as c on o.cust_id =c.cust_id) as s2 
on s1.order_num=s2.order_num order by total_price

全部评论

相关推荐

06-12 16:00
天津大学 Java
牛客30236098...:腾讯坏事做尽,终面挂是最破防的 上次被挂了后我连简历都不刷了
点赞 评论 收藏
分享
06-11 17:39
门头沟学院 Java
小呆呆的大鼻涕:卧槽,用户彻底怒了
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

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