题解 | #计算总和#

select order_num, sum(item_price * quantity) AS total_price from OrderItems
group by
    order_num
having
    sum(item_price * quantity) >= 1000
order by
    order_num ASC
#【问题】编写 SQL 语句，根据订单号聚合，返回订单总价不小于1000 的所有订单号，最后的结果按订单号进行升序排序。
提示：总价 = item_price 乘以 quantity