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