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

SELECT 
    gender, university, COUNT(device_id) AS user_num, AVG(active_days_within_30) AS avg_active_days, AVG(question_cnt) AS avg_question_cnt
FROM user_profile
GROUP BY gender, university