题解 | #统计每个用户的平均刷题数#
统计每个用户的平均刷题数
https://www.nowcoder.com/practice/f4714f7529404679b7f8909c96299ac4
select b.university as university ,c.difficult_level as difficult_level ,count(1)/ count(distinct a.device_id) as difficult_level from question_practice_detail a left join user_profile b on a.device_id = b.device_id and b.university = '山东大学' left join question_detail c on a.question_id = c.question_id where b.device_id is not null group by 1,2
查看11道真题和解析
投递OPPO等公司8个岗位