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

select ue.university,count(qe.device_id)/count(distinct ue.device_id) from user_profile ue join question_practice_detail qe on ue.device_id=qe.device_id
group by ue.university order by ue.university;