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

SELECT
    gender,
    university,
    count(gender) AS user_num,
    round(avg(active_days_within_30),1) AS avg_active_day,
    round(avg(question_cnt),1) AS avg_question_cnt
FROM
    user_profile
GROUP BY gender,university
ORDER BY gender,university