select
    u.university
    ,count(qp.question_id)/count(distinct(u.device_id))
from question_practice_detail qp 
     left join user_profile u on u.device_id=qp.device_id
group by 1
order by 1