select
    university,
    round(count(q.result) / count(distinct q.device_id), 4) as avg_answer_cnt
from
    user_profile u
    JOIN question_practice_detail q
WHERE
    u.device_id = q.device_id
GROUP BY
    university;