题解 | 计算总和
select order_num,sum(item_price * quantity) total_price from OrderItems group by order_num having sum(item_price * quantity) >= 1000 order by order_num
select order_num,sum(item_price * quantity) total_price from OrderItems group by order_num having sum(item_price * quantity) >= 1000 order by order_num
相关推荐
查看13道真题和解析