题解 | #计算总和#
计算总和
https://www.nowcoder.com/practice/d8a624021183454586da94d280cc8046
select order_num,sum(item_price*quantity) as total_prrice from OrderItems group by order_num having total_prrice>=1000
计算总和
https://www.nowcoder.com/practice/d8a624021183454586da94d280cc8046
select order_num,sum(item_price*quantity) as total_prrice from OrderItems group by order_num having total_prrice>=1000
相关推荐
asdasdasda...:我前段时间找工作焦虑,有几天连续熬夜熬穿了,然后心脏突然不舒服,立马躺床上睡觉了,然后第二天还是不舒服,去看医生说是心率不齐,吓得我后面天天早早睡觉,调养身体,过了好几天才好过来。所以真的,工作这些东西哪有那么重要,最多钱多一点钱少一点,降低物欲。活着才是最重要的,现在想想真的后怕
沉淀小子:干啥都不丢人啊,生存是必须要的,销售很考验一个人综合素质能力的,好的销售人脉和资源可不比写字楼的白领差啊