上道题同个思路,做好各个表之前的嵌套及条件筛选、最后做好表格的分组及排序即可 select level, count(*) level_cnt from exam_record e join user_info using(uid) join examination_info i using(exam_id) where score>80 and tag="SQL" group by level order by level_cnt desc