select up.university, qd.difficult_level, convert( Count(qpd.id) / Count(DISTINCT up.id), decimal(15, 4) ) avg_answer_cnt from question_practice_detail qpd inner join user_profile up on up.device_id = qpd.device_id inner join question_detail qd on qd.quest...