题解 | #作答试卷得分大于过80的人的用户等级分布#
作答试卷得分大于过80的人的用户等级分布
https://www.nowcoder.com/practice/5bc77e3a3c374ad6a92798f0ead4c744
select
t1.level,
count(t1.uid) as level_cnt
from
user_info t1,
examination_info t2,
exam_record t3
where
t1.uid = t3.uid
and t2.exam_id = t3.exam_id
and t2.tag = 'SQL'
and t3.score > 80
group by
t1.level
order by
level_cnt desc
查看3道真题和解析