题目描述:
https://www.nowcoder.com/practice/88aa923a9a674253b861a8fa56bac8e5
思路:首先连接user_profile和question_practice_detail,按照学校进行分组
计算平均做题数可以用question_id总数/不重复的device_id数
select u.university,(count(q.question_id)/count(distinct(q.device_id))) avg_answer_cnt from user_profile as u,question_practice_detail as q
where u.device_id=q.device_id
group by u.university