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

京公网安备 11010502036488号