题解 | #返回更多的产品#
返回更多的产品
https://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
SELECT order_num FROM OrderItems GROUP BY order_num HAVING SUM(quantity) >= 100;重点:GROUP BY分组 + SUM 组内求和 + HAVING 过滤
#sql#
返回更多的产品
https://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
SELECT order_num FROM OrderItems GROUP BY order_num HAVING SUM(quantity) >= 100;重点:GROUP BY分组 + SUM 组内求和 + HAVING 过滤
相关推荐
萨德楽陈:能进去你就是最牛逼的,不会学就完了招聘动态