select up.university,count(qpd.question_id) / count( distinct qpd.device_id) avg_answer_cnt from user_profile up join question_practice_detail qpd where up.device_id = qpd.device_id group by up.university;