题解 | #分组计算练习题#

select gender,university,count(device_id) user_num,format(avg(active_days_within_30),1) avg_active_day,format(avg(question_cnt),1) avg_question_cnt from user_profile group by gender,university;