SELECT
ui. LEVEL,
count(*) level_cnt
FROM
examination_info ei
JOIN exam_record er USING (exam_id)
JOIN user_info ui USING (uid)
WHERE
score > 80
AND tag = "SQL"
GROUP BY
ui. LEVEL
ORDER BY
level_cnt DESC
ui. LEVEL,
count(*) level_cnt
FROM
examination_info ei
JOIN exam_record er USING (exam_id)
JOIN user_info ui USING (uid)
WHERE
score > 80
AND tag = "SQL"
GROUP BY
ui. LEVEL
ORDER BY
level_cnt DESC