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 group by gender, university//进行分组GROUP BY 语句用于结合合计函数,根据一个或多个列对结果集进行分组。合计函数 (比如 SUM) 常常需要添加...