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

SELECT A.university,A.avg_question_cnt,A.avg_answer_cnt FROM 
(SELECT university ,AVG(question_cnt) AS avg_question_cnt,AVG(answer_cnt) AS avg_answer_cnt FROM user_profile  GROUP BY university) A  WHERE A.avg_question_cnt<5 OR A.avg_answer_cnt<20