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;
Copy this HTML code:
Preview:
open_in_newInstructions on embedding in Medium
Comments