题解 | #计算总和#
计算总和
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;
select order_num, sum(item_price * quantity) as total_price from OrderItems
GROUP BY order_num
HAVING total_price >= 1000;
#MySQL#
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给他按组过滤以下
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;
查看13道真题和解析