题解 | #作答试卷得分大于过80的人的用户等级分布#
作答试卷得分大于过80的人的用户等级分布
https://www.nowcoder.com/practice/5bc77e3a3c374ad6a92798f0ead4c744
select level,count(level) as level_cnt
from user_info
where uid in (select distinct uid from exam_record
where exam_id in (
select exam_id from examination_info
where tag = 'SQL'
) and score > 80)
group by level
order by level_cnt desc;
投递滴滴等公司7个岗位 >