一张学生成绩表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