using row between to cummulative sum

PHOTO EMBED

Mon Mar 21 2022 02:49:01 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

select *, sum(sale)over(order by yyyy rows between unbounded preceding and current row)
from(
select sum(sales) as sale,extract(year from order_date)yyyy
from orders_table as ot
group by 2
order by 2 asc
)t1;
content_copyCOPY