select distinct university, round(count(question_id) / count(distinct u.device_id), 4) as avg_answer_cnt from user_profile u left join question_practice_detail p on u.device_id =&nbs...