select university,count(question_id)/count(distinct a.device_id) avg_answer_cnt
from user_profile a
inner join question_practice_detail b
on a.device_id = b.device_id
group by university
order by university