题解 | #返回更多的产品#
返回更多的产品
https://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
select order_num from OrderItems group by order_num having sum(quantity)>=100;
order_num 中有多个重复数据,其对应多个quantity,所以最后求的是将该数据的多个quantity相加的值>=100
返回更多的产品
https://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
select order_num from OrderItems group by order_num having sum(quantity)>=100;
order_num 中有多个重复数据,其对应多个quantity,所以最后求的是将该数据的多个quantity相加的值>=100
相关推荐