题解 | 分组计算练习题
select gender, university, count(gender) user_num, round(avg(active_days_within_30), 1) avg_active_day, round(avg(question_cnt), 1) avg_question_cnt from user_profile group by university, gender order by gender, university
select gender, university, count(gender) user_num, round(avg(active_days_within_30), 1) avg_active_day, round(avg(question_cnt), 1) avg_question_cnt from user_profile group by university, gender order by gender, university
相关推荐