题解 | 计算总和
SELECT o.order_num, SUM(o.item_price * o.quantity) AS total_price FROM OrderItems AS o GROUP BY o.order_num HAVING total_price >=1000 ORDER BY o.order_num;
SELECT o.order_num, SUM(o.item_price * o.quantity) AS total_price FROM OrderItems AS o GROUP BY o.order_num HAVING total_price >=1000 ORDER BY o.order_num;
相关推荐
只想搞钱的鸽子很喜欢...:混账是很多的,还有那些在自己风华正茂的年纪说风凉话讥讽那些下岗前员工的。这些人都是现在职场环境这么烂的帮凶