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;