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; 方法二:使用子查询select * from (select university, avg(question_cnt) as avg_question_cnt, avg(answer_cnt) as avg...