select
    up.gender,
    up.university,
    count(1) as user_num,
    AVG(up.active_days_within_30) as avg_active_day,
    AVG(up.question_cnt) as avg_question_cnt
from
    user_profile up
group by
    up.gender,
    up.university
order by up.gender