select gender, university, count(*), avg(active_days_within_30), avg(question_cnt) from user_profile group by gender, university group by university,gender 反过来也可以但是如下情况不行,会报错:不满足函数依赖 select gender, university, count(*), avg(active_days_within_30), avg(question_cnt) from user_profile group by gende...