select
    YEAR_MONTH,
    MONTH_AMT,
    sum(MONTH_AMT) over(order by YEAR_MONTH ROWS UNBOUNDED PRECEDING) as CUML_AMT,
    sum(MONTH_AMT) over(order by YEAR_MONTH ROWS 11 PRECEDING) as YEAR_MOVE_AMT
from
(
    select
        strftime("%Y-%m",SALES_DATE) as YEAR_MONTH,
        sum(SALES_AMT) as MONTH_AMT
    from SALES
    where
        UPDATED_NO is null
        and SALES_DATE between '2023-01-01' and '2023-12-31'
    group by
        YEAR_MONTH
)
order by
    YEAR_MONTH
;