题解 | 计算总和
select order_num, sum(item_price * quantity) total_price from test.OrderItems group by order_num having sum(item_price * quantity) >= 1000 order by order_num asc
select order_num, sum(item_price * quantity) total_price from test.OrderItems group by order_num having sum(item_price * quantity) >= 1000 order by order_num asc
相关推荐