select
university
,round(count(*)/count(distinct u.device_id),4)  avg_answer_cnt
# count(*)代表group by分组之后 每个组含有多少行，然后计数
from user_profile u
join question_practice_detail q
on u.device_id = q.device_id
group by 1 
order by university