1.分析
sum over用法,先对grade排序,然后依次计算各个sum。

2.代码

select grade, sum(number) over(order by grade) t_rank 
from class_grade 
order by grade;