题解 | #分组过滤练习题#
分组过滤练习题
https://www.nowcoder.com/practice/ddbcedcd9600403296038ee44a172f2d
SELECT
university,
ROUND(AVG(question_cnt), 3) AS avg_question_cnt,
ROUND(AVG(answer_cnt), 3) AS avg_answer_cnt
FROM
user_profile
GROUP BY
university
HAVING
avg_question_cnt < 5
OR avg_answer_cnt < 20
投递哔哩哔哩等公司10个岗位 >
