https://www.youtube.com/watch?v=bVmSJyqsj7A

create table new_sale(
Date date,
salary int
)

insert into new_sale values('2024-01-01', 100),
('2024-01-02',800),
('2024-01-03',1100),
('2024-01-04',1200),
('2024-01-05',1300),
('2024-01-06',1400),
('2024-01-07',1500),
('2024-01-08',1600),
('2024-01-09',1700),
('2024-01-10',1800)

select 
	a.date,
    SUM(b.salary) AS Sum
from ns a

JOIN ns b
ON a.date >= b.date 
group by a.date
order by sum