题解 | #计算总和#
计算总和
https://www.nowcoder.com/practice/d8a624021183454586da94d280cc8046
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
计算总和
https://www.nowcoder.com/practice/d8a624021183454586da94d280cc8046
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
相关推荐
27届学院本誓死冲击...:下次再发把个人信息隐藏掉,以防有心之人。相关课程删了,荣誉奖项只留蓝桥杯,把蓝桥杯写到教育经历里,按教育经历、实习经历、项目经历、专业技能这个顺序排版