题解 | #计算总和#

计算总和

https://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;

我在写这道题的时候的思路就是
1. 先把每一行的总价钱给他算出来
select order_num, item_price * quantity as total_price from OrderItems

2. 之后按订单号分组,并计算出每一组的总价
select order_num, sum(item_price * quantity) as total_price from OrderItems
GROUP BY order_num
3. 加上having给他按组过滤以下

select order_num, sum(item_price * quantity) as total_price from OrderItems
GROUP BY order_num
HAVING total_price >= 1000;


#MySQL#
全部评论

相关推荐

点赞 评论 收藏
分享
弦五Strings:他之所以会举报你代课是因为在这种人眼里正常上课就是正义代课就是邪恶,典型二极管思维,处理方法就是私下沟通,你就说你自己家里经济困难或者家里父母生病什么之类的,需要去打工挣钱,用尽孝的正义对冲他认为的上课的正义,他可能就妥协了。
我的实习日记
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

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