SELECT university ,COUNT(q.question_id)/COUNT(DISTINCT u.device_id)FROM user_profile AS u JOIN question_practice_detail AS q ON u.device_id=q.device_id GROUP BY university 去重这一步比较重要