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;
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;