select university, detail.difficult_level, count(detail.question_id)/count(distinct detail.device_id) from (select qpd.device_id ,qd.question_id, difficult_level from question_detail qd, question_practice_detail qpd where qd.question_id = qpd.question_id) as detail, user_profile where detail.device_...