Byte_Dancing
Byte_Dancing
全部文章
分类
题解(4)
归档
标签
去牛客网
登录
/
注册
Byte_Dancing的博客
全部文章
(共1篇)
题解 | #统计每个学校的答过题的用户的平均答题数#
select u.university, ( count(q.question_id) / count(distinct u.device_id) ) as avg_answer_cnt from user_profile as u, question_practice_detail as q wh...
Mysql
2022-04-08
0
188