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

分组计算练习题

https://www.nowcoder.com/practice/009d8067d2df47fea429afe2e7b9de45

select up.gender,up.university,count(*) 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.university,up.gender;

全部评论

相关推荐

大摆哥:刚好要做个聊天软件,直接让你帮他干活了
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务