题解 | #返回更多的产品#
返回更多的产品
http://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
select order_num
from OrderItems
group by order_num
having sum(quantity) >= 100;
个人理解,同个order_num应该累加数量。
返回更多的产品
http://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
select order_num
from OrderItems
group by order_num
having sum(quantity) >= 100;
个人理解,同个order_num应该累加数量。
相关推荐