SELECT level, COUNT(DISTINCT uid) level_cnt FROM exam_record a JOIN user_info b USING(uid) JOIN examination_info c USING(exam_id) WHERE c.tag = 'SQL' AND score > 80 GROUP BY level ORDER BY level_cnt DESC, level DESC
承接上一题,根据exam_record表联结另外两个表,对应4,5行
限制条件对应6行
最后要输出等级和数量,并且首先按数量倒排,再按等级倒排,对应7,8行