select 
strftime('%Y-%m', date(s1.sales_date)) as YEAR_MONTH,
sum(s1.sales_amt) as MONTH_AMT,
(select total(s2.sales_amt) from sales as s2 where s2.updated_no is null and s2.sales_date between '2023-01' and strftime('%Y-%m', date(s1.sales_date, '+1 months'))) as CUML_AMT,
(select total(s3.sales_amt) + sum(s1.sales_amt) from sales as s3 where s3.updated_no is null and s3.sales_date between strftime('%Y-%m', date(s1.sales_date, '-11 months')) and strftime('%Y-%m', date(s1.sales_date, '+0 months'))) as YEAR_MOVE_AMT
from sales as s1
where s1.updated_no is null and s1.sales_date between '2023-01' and '2023-12'
group by YEAR_MONTH
order by YEAR_MONTH asc