with monthly_sales as(
select strftime('%Y-%m', SALES_DATE) as MONTH,
SUM(SALES_AMT) as SALES_AMT
from SALES
where UPDATED_NO is null
group BY MONTH
order by MONTH
),
tmp as(
select 
t1.MONTH as YEAR_MONTH,
t1.SALES_AMT as MONTH_AMT,
SUM(
case
when t2.MONTH >= "2023-01" and t2.MONTH <=t1.MONTH then t2.SALES_AMT
else 0
end
) as CUML_AMT,
SUM(
case
when t1.MONTH >= t2.MONTH and ((CAST(STRFTIME('%Y', date(t1.MONTH||"-01")) AS INTEGER) - CAST(STRFTIME('%Y', date(t2.MONTH||"-01")) AS INTEGER)) * 12 +
    (CAST(STRFTIME('%m',date(t1.MONTH||"-01")) AS INTEGER) - CAST(STRFTIME('%m', date(t2.MONTH||"-01")) AS INTEGER)) < 12) then t2.SALES_AMT
else 0
end
) as YEAR_MOVE_AMT
from monthly_sales t1 JOIN monthly_sales t2 
group BY YEAR_MONTH
)
select * from tmp where YEAR_MONTH between "2023-01" and "2023-12"