窗口函数,不用分组,直接number求和
select grade, sum(number) over(order by grade) as t_rank from class_grade order by grade;