1、HAVING
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&nbs***bsp;avg(answer_cnt) <20;
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&nbs***bsp;avg(answer_cnt) <20;