select gender,university,count(device_id) as 'user_num', avg(active_days_within_30) as 'avg_active_day', avg(question_cnt) as 'avg_question_cnt' from user_profile group by gender,university order by gender; 题目要求:1.需要对性别和学校进行分组 2. 查询出来的结果按照gender升序排列所以用到的关键字:聚合函数,分组group by 和 order by