题解 | #分组过滤练习题#

SELECT
university,
avg(question_cnt),
avg(answer_cnt)
from user_profile
group by university
having avg(question_cnt)<5
or
avg(answer_cnt)<20

考点group by having
按照大学进行分组 group by university，条件having avg(question_cnt)<5 or avg(answer_cnt)<20