SQL18题解 | #分组计算练习题#
分组计算练习题
https://www.nowcoder.com/practice/009d8067d2df47fea429afe2e7b9de45
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;
#SQL练习#SQL专项练习 文章被收录于专栏
SQL语句
查看7道真题和解析