嵌套子查询,题目没有说清楚,后面level个数相同时用level进行排序

select level,count(distinct uid) as level_cnt from user_info where uid in (select uid 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 ,level desc