select up.university,
       round(count(qpd.question_id)/count(distinct qpd.device_id), 4) as avg_answer_cnt
from question_practice_detail qpd
join user_profile up
using(device_id)
group by up.university
order by up.university;

终于对了！