select gender,university,count(device_id) user_num,round(avg(active_days_within_30),1) avg_active_day, round(sum(question_cnt)/count(device_id),1) avg_question_cnt from user_profile group by gender,university