#答题总数量

select count(question_id) from question_practice_detail

#用户id

select count(distinct device_id) from user_profile

最终结果： select p.university,count(d.question_id) / count(distinct p.device_id) from user_profile p join question_practice_detail d on p.device_id = d.device_id group by p.university