```select
    level,
    count(*) level_cnt
from user_info
left join exam_record using(uid)
left join examination_info using(exam_id)
where score>80
    and tag='SQL'
group by level
order by level_cnt desc

left join 连接表
根据要求过滤
要什么就求什么