windowfunctionSchema_1.sql

DROP TABLE IF EXISTS demand2;

CREATE TABLE demand2 (
  day INT,
  qty FLOAT
);


INSERT INTO demand2
  (day, qty)
VALUES
  (1, 10),
  (2, 6),
  (3, 21),
  (4, 9),
  (6, 12),
  (7, 18),
  (8, 3),
  (9, 6),
  (10, 23);

select day,qty,cume_dist(qty) over(order by qty)as cum_qty
from demand2;