窗口函数,不用分组,直接number求和

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