get total sales per quarter, every year
Wed Mar 02 2022 02:49:43 GMT+0000 (Coordinated Universal Time)
Saved by
@Bambibo9799
--------------dapatkan total sales di tiap quarter per tahun di tabel order
select *, lag(totalsales, 1) over(partition by year order by q_quarter) as previousquartersales
from(
select totalsales,year,concat('Q','', quarter) as Q_quarter
from(
select round(sum(ot.sales)) as totalsales,
extract(year from order_date)as year,
extract(quarter from order_date) as quarter
from orders_table as ot
group by 2,3
order by 2,3 asc
) t1
) t2
----------------
select *, lag(ss)over(partition by region,y order by y, q asc)
from(
select extract(year from order_date) as y, extract(quarter from order_date)as q, sum(sales)as ss, region
from orders_table as ot
group by 1,2,4
)t1
content_copyCOPY
Comments