首页 > 试题广场 >

处理用户评论表comments(comment_id, pr

[单选题]

处理用户评论表comments(comment_id, product_id, user_id, score)时，需要列出每个产品的平均分，并排除评分用户少于10人的产品。正确实现是？

SELECT product_id, AVG(score) avg_score FROM comments GROUP BY product_id WHERE COUNT(user_id)>=10

SELECT product_id, AVG(score) avg_score FROM comments HAVING COUNT(DISTINCT user_id)>=10 GROUP BY product_id

SELECT product_id, AVG(score) avg_score FROM comments GROUP BY product_id HAVING COUNT(DISTINCT user_id)>=10

SELECT product_id, AVG(score) avg_score FROM comments WHERE COUNT(user_id)>=10 GROUP BY product_id

查看正确选项

牛客441813586号

先groupby再havingcount

发表于 2026-05-24 20:54:06 回复(0)

提交观点

问题信息

SQL

难度：

1条回答 23收藏 30浏览

扫一扫，把题目装进口袋