如下: select university,difficult_level,count(qpd.question_id)/count(distinct qpd.device_id) avg_answer_cnt from user_profile as upr left join question_practice_detail as qpd on upr.device_id=qpd.device_id left join question_detai...