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

select 
    university,count(university) /count(distinct q.device_id)
from 
    user_profile u, question_practice_detail q 
where 
    u.device_id=q.device_id 
group by
    u.university
order by
    u.university;