SQL89 计算总和

计算总和_牛客题霸_牛客网 (nowcoder.com)https://www.nowcoder.com/practice/d8a624021183454586da94d280cc8046?tpId=298&tqId=2374683&ru=/exam/oj&qru=/ta/sql-teach-yourself/question-ranking&sourceUrl=%2Fexam%2Foj%3Fpage%3D1%26tab%3DSQL%25E7%25AF%2587%26topicId%3D298

首先分组，分组后算总价，分组后虽然一个单元格好个数据，但是和原表是对应的

所以我们可以使用sum(item_price*quantity)

一开始不晓得，使用了子查询，先把每个订单的总价算出来，如何再去求和

select 
    order_num,
    sum(total) as total_price
from (select 
            order_num,
            item_price * quantity as total
        from OrderItems) q
group by order_num
having total_price >= 1000
order by order_num

第二种方法

select 
    order_num,
    sum(item_price*quantity) as total_price 
from OrderItems 
group by order_num 
having total_price >=1000 
order by order_num;