select university,count(question_id)/count(distinct device_id) as avg_answer_cnt
from
(select a.device_id,a.university,b.question_id
from user_profile a
left join question_practice_detail b
on a.device_id = b.device_id 
where question_id is not null)t
group by university
order by university;