select university,difficult_level,round(count(question_id)/count(distinct device_id),4) as avg_answer_cnt from ( select q.device_id, u.university, q.question_id, qu.difficult_level from question_practice_detail q inner join user_profile u on q.device_id = u.device_id inner join question_detail qu on...