SELECT up.university, ROUND(COUNT(qpd.question_id) / COUNT(DISTINCT qpd.device_id), 4) AS avg_answer_cntFROM user_profile AS upLEFT JOIN question_practice_detail AS qpdON up.device_id = qpd.device_idGROUP BY up.university;