题解 | #作答试卷得分大于过80的人的用户等级分布#
作答试卷得分大于过80的人的用户等级分布
https://www.nowcoder.com/practice/5bc77e3a3c374ad6a92798f0ead4c744
SELECT
level,
count(uid) level_cnt
from
user_info
where
uid in (
SELECT
er.uid
FROM
`exam_record` er
join examination_info ei on er.exam_id = ei.exam_id
where
tag = 'SQL'
and score > 80
)
group by
level
order by
level_cnt desc;
投递小鹏汽车等公司10个岗位