题解 | 计算总和
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;
相关推荐