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行

京公网安备 11010502036488号