题解 | #返回更多的产品#
返回更多的产品
https://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
select order_num from OrderItems group by order_num having sum(quantity) >= 100
知识点:
分组后使用having进行结果集的筛选
返回更多的产品
https://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
select order_num from OrderItems group by order_num having sum(quantity) >= 100
知识点:
分组后使用having进行结果集的筛选
相关推荐