select university, count(qp.question_id)/count(distinct(qp.device_id)) avg_answer_cnt from question_practice_detail qp,user_profile up where qp.device_id=up.device_id group by up.university order by up.university asc
