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