SELECT  gender, university, 
        count(device_id)                        AS user_num, 
        round(avg(active_days_within_30), 1)    AS avg_active_day,  #30天内平均活跃天数
        avg(question_cnt)                       AS avg_question_cnt #平均发帖数量
    FROM user_profile
    group by gender,university;