怎么用sql语句对学生成绩进行排名？

Question

一张学生成绩表assess_score，
有total_score（总成绩)，id，student_name(姓名)，student_number(学号)，
assess_year(学年)，根据总成绩进行成绩排名，需要考虑重复成绩和每个学年的成绩排名

这是我写的 请大佬帮我改一下

SELECT assess_year,student_number,id,SUM(courseScore),DENSE_RANK() OVER(ORDER BY SUM(courseScore) DESC ) as Ranking
            FROM course_score As courseScore group by student_number,assess_year,id

Answer 1

SELECT
SUM( total_score ) score,
assess_year
FROM
course_score
GROUP BY
student_number,
assess_year
ORDER BY
score