SELECT grade
      ,MAX(t_rank) AS t_rank
FROM
(SELECT *
      ,SUM(NUMBER) OVER(ORDER BY grade ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS t_rank
FROM class_grade
) AS t1
GROUP BY grade