题解 | #计算总和#
计算总和
http://www.nowcoder.com/practice/d8a624021183454586da94d280cc8046
- select order_num,sum(item_price * quantity) as total_price
- from OrderItems
- group by order_num
- having total_price >= 1000
- order by order_num asc
本题不可以直接在 quantity前面加sum函数，item_price不在聚合键里，所以会报错。
投递京东等公司10个岗位
滴滴一面359人在聊