select university, difficult_level, round(avg(one_answer_cnt), 4) as avg_answer_cnt from ( select university, c.difficult_level, count(a.device_id) as one_answer_cnt from user_profile a inner join question_pr...