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