select university,difficult_level,count(dl.question_id)/count(distinct up.device_id) avg_answer_cnt from (select device_id,qpd.question_id question_id,difficult_level from question_practice_detail as qpd join question_detail as qd on qpd.question_id=qd.question_id) dl inner join user_profile as up o...