-- create a table
CREATE TABLE students (
  name TEXT ,
  score INTEGER 
  -- ,gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES ('a', 5);
INSERT INTO students VALUES ('x', 10);
INSERT INTO students VALUES ('d', 2);
INSERT INTO students VALUES ('m', 5);
-- fetch some values
with row_table as (SELECT * ,  ROW_NUMBER() OVER (ORDER BY name) as row_num FROM students)
    select r1.name, r1.score, sum(r2.score) as cum_sum from row_table r1 join row_table r2 on r1.row_num >= r2.row_num
    group by r1.name,r1.score
        order by cum_sum;