题解 | #统计每个学校的答过题的用户的平均答题数#

select t2.university,count(t1.device_id)/count(distinct t1.device_id) from question_practice_detail t1 left join user_profile t2 on t1.device_id=t2.device_id group by t2.university;