SQL22 题解 | #统计平均答题数#

select
university,round(count(question_id)/count(distinct question_practice_detail.device_id),4) as avg_answer_cnt
from user_profile,question_practice_detail
where user_profile.device_id = question_practice_detail.device_id group by university