with monthly_report as(
select 
     strftime('%Y-%m', sales_date) YEAR_MONTH
    ,sum(sales_amt) month_amt    
from sales
where 
    updated_no is null
group by strftime('%Y-%m', sales_date)
)
, month_accum as (
    select 
        YEAR_MONTH, 
        sum(month_amt) over (order by year_month) cuml_amt
    from monthly_report
    where
        YEAR_MONTH >= '2023-01'
)
, move_report as (
    select 
        year_month,
        sum(month_amt) over (
            order by year_month 
            rows between 11 preceding and current row
        ) year_move_amt
    from monthly_report
)
select 
     MR.year_month     YEAR_MONTH
    ,MR.month_amt      MONTH_AMT
    ,MA.cuml_amt       CUML_AMT
    ,MOR.year_move_amt YEAR_MOVE_AMT
from monthly_report MR
INNER JOIN month_accum MA
ON MR.year_month = MA.year_month
INNER JOIN move_report MOR
ON MR.year_month = MOR.year_month
where 
    MR.YEAR_MONTH BETWEEN '2023-01' and '2023-12'
ORDER BY year_month
;