select t1.university, count(t2.question_id) / count(distinct t1.device_id) avg_answer_cnt from user_profile t1 inner join question_practice_detail t2 on t1.device_id = t2.device_id group by university;
select t1.university, count(t2.question_id) / count(distinct t1.device_id) avg_answer_cnt from user_profile t1 inner join question_practice_detail t2 on t1.device_id = t2.device_id group by university;