题解 | 统计每个学校各难度的用户平均刷题数
统计每个学校各难度的用户平均刷题数
https://www.nowcoder.com/practice/5400df085a034f88b2e17941ab338ee8
select dx.university,level.difficult_level ,round(count(t1.question_id)/count(distinct t1.device_id),4)as avg_answer_cnt from question_practice_detail as t1 left join user_profile as dx on t1.device_id=dx.device_id left join question_detail as level on t1.question_id=level.question_id group by 1,2
智元机器人成长空间 270人发布