问题是经典的累积求和，用sum(number) over(order by grade) 即可得出。

SELECT grade , SUM(number) OVER(ORDER BY grade) t_rank FROM class_grade