select
strftime('%Y-%m', SALES_DATE) as YEAR_MONTH
, sum(SALES_AMT) as MONTH_AMT
, (
select
sum(SALES_AMT)
from
SALES sub
where
strftime('%Y-%m', sub.SALES_DATE) <= strftime('%Y-%m', sa.SALES_DATE) 
and SALES_DATE between '2023-01-01' and '2023-12-31'
and UPDATED_NO is null
) as CUML_AMT
, (
select
sum(SALES_AMT)
from
SALES sub
where
strftime('%Y-%m', sub.SALES_DATE) between strftime('%Y-%m', sa.SALES_DATE,'-11 month') and strftime('%Y-%m', sa.SALES_DATE) 
and UPDATED_NO is null
) as YEAR_MOVE_AMT
from SALES as sa
where SALES_DATE between '2023-01-01' and '2023-12-31'
and UPDATED_NO is null
group by YEAR_MONTH