题解 | #作答试卷得分大于过80的人的用户等级分布#

select level,count(uid) level_cnt
from user_info
where uid in 
(select uid from exam_record
where exam_id in (select exam_id from examination_info ei
where tag = "SQL") 
and score > 80)
group by level
order by level_cnt desc