题解 | #作答试卷得分大于过80的人的用户等级分布#
作答试卷得分大于过80的人的用户等级分布
https://www.nowcoder.com/practice/5bc77e3a3c374ad6a92798f0ead4c744
#对比前两条确实大巫见小巫，简单多了，前两条最怕是连题目都没读清 select level,count(distinct ui.uid) as level_cnt from exam_record as er join user_info as ui on er.uid=ui.uid join examination_info as ei on er.exam_id=ei.exam_id where ei.tag = "SQL" and er.score >80 group by ui.level order by level_cnt DESC,level DESC
查看9道真题和解析