select up.university, qd.difficult_level, round((count(qpd.question_id)/count(distinct(qpd.device_id))),4) as avg_answer_cnt from user_profile up left join question_practice_detail qpd ...