with a as(select 
level,ui.uid,score

from exam_record er 
join examination_info ei on ei.exam_id = er.exam_id
join user_info ui on ui.uid= er.uid

where score >80
and tag='SQL')

select level,count(*) as level_cnt
from a 
group by level
order by level_cnt desc,level desc

简单