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

select level, count(uid) level_cnt
from user_info
where uid in (
    select uid
    from exam_record
    where exam_id = 9001 
    and score > 80
)
group by level
order by level_cnt desc;