select grade,
SUM(number) OVER (ORDER BY grade) AS t_rank
from
class_grade
关键：SUM(a) OVER (ORDER BY b) 窗口函数按照 b 排序，然后逐行计算从结果集开始到当前行的 a 字段的累计总和。