SELECT u.university, round(count(q.result)/count(DISTINCT q.device_id),4) avg_answer_cnt
FROM user_profile u
JOIN question_practice_detail q
ON u.device_id = q.device_id
GROUP BY university