select 
	gender, university, count(device_id) 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 1,2
order by 1