select D.university, D.difficult_level, count(D.question_cnt)/count(distinct D.device_id) as avg_answer_cnt from( select A.university,B.device_id,A.question_cnt,B.question_id, C.difficult_level from user_profile as A right join question_practice_detail as B on A.device_id = B.device_id left join q...