WITH SUB AS ( 
    select
        strftime('%Y-%m', SALES_DATE) as YM
        , SUM(SALES_AMT) as MON_AMT 
    from
        SALES 
    where
        UPDATED_NO ISNULL 
    GROUP by
        YM
) 
, Z_CHART as ( 
    select
        YM as YEAR_MONTH
        , MON_AMT as MONTH_AMT
        , SUM(MON_AMT) OVER ( 
            ORDER BY
                YM ROWS BETWEEN 11 PRECEDING AND CURRENT ROW
        ) as YEAR_MOVE_AMT 
    from
        ( 
            select
                strftime('%Y-%m', SALES_DATE) as YM
                , SUM(SALES_AMT) as MON_AMT 
            from
                SALES 
            where
                UPDATED_NO ISNULL 
            GROUP by
                YM
        )
) 
select
    YEAR_MONTH
    , MONTH_AMT
    , SUM(MONTH_AMT) OVER (order by Year_MONTH) as CUML_AMT
    , YEAR_MOVE_AMT 
from
    Z_CHART 
where
    year_month between '2023-01' and '2023-12' 
order by
    Year_month ASC;