with target_amt as (
    select 
        strftime('%Y-%m', SALES_DATE) as YEAR_MONTH
        , CAST(strftime('%Y%m', SALES_DATE) AS INTEGER) as YEAR_MONTH_INT
        , sum(SALES_AMT) as MONTH_AMT
    from
        SALES
    where
        UPDATED_NO is null
    group by
        strftime('%Y-%m', SALES_DATE)
)
select
    t1.YEAR_MONTH
    , MONTH_AMT
    , CUML_AMT
    , YEAR_MOVE_AMT
from
    target_amt t1
    left outer join (
        select
            YEAR_MONTH
            , sum(MONTH_AMT) over(order by YEAR_MONTH) as CUML_AMT
        from target_amt
        where
            YEAR_MONTH_INT between 202301 and 202312
    ) t2
        on t1.YEAR_MONTH = t2.YEAR_MONTH
    left outer join (
        select
            YEAR_MONTH
            , sum(MONTH_AMT) over(order by YEAR_MONTH rows between 11 preceding and current row) as YEAR_MOVE_AMT
        from target_amt
    ) t3
        on t1.YEAR_MONTH = t3.YEAR_MONTH
where
    t1.YEAR_MONTH_INT between 202301 and 202312
order by 
    t1.YEAR_MONTH
;