笨办法
SELECT
order_num,
COUNT(order_num) AS items
FROM OrderItems
GROUP BY order_num HAVING items >= 3 ORDER BY items ASC
SELECT
order_num,
COUNT(order_num) AS items
FROM OrderItems
GROUP BY order_num HAVING items >= 3 ORDER BY items ASC
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2F3870c9bca7a4406f899af3e903b8bf51
全部评论
相关推荐
11-30 22:14
门头沟学院 Java
沉淀小子:我们所追求的是想生活滋润一点,不求大富大贵,但是吃穿住行方面不用抠抠搜搜,不用每天看看有没有性价比的外卖和拼好饭,住城中村的压抑,出门打特惠快车几个平台对比,每个月买几件便宜衣服取悦自己 点赞 评论 收藏
分享
点赞 评论 收藏
分享

