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;