select
    university,
    avg(question_cnt) as avg_question_cnt,
    avg(answer_cnt) as avg_answer_cnt
from
    user_profile
group by
    university
having
    avg(question_cnt) < 5 or avg(answer_cnt) < 20

最后输出三列:university,university对应的avg_question_cnt,university对应的avg_answer_cnt

可以看出以university为聚合依据,求发帖均值和回帖均值仅需一个简单的avg聚合函数,而满足筛选条件仅需一个having子句。