WITH A AS(
    SELECT 
        strftime('%Y-%m', SALES_DATE) AS 'YEAR_MONTH',
        SUM(SALES_AMT) AS 'MONTH_AMT',
        SUM(SUM(SALES_AMT)) over(PARTITION  BY strftime('%Y', SALES_DATE) order by strftime('%Y-%m', SALES_DATE)) AS 'CUML_AMT',
        SUM(SUM(SALES_AMT)) over(order by strftime('%Y-%m', SALES_DATE) ROWS 11 PRECEDING) AS 'YEAR_MOVE_AMT'
    FROM
        SALES
    WHERE
        UPDATED_NO is NULL
    GROUP BY
    	strftime('%Y-%m', SALES_DATE)
    ORDER BY
        'YEAR_MONTH'
)

SELECT 
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT,
    YEAR_MOVE_AMT
FROM
    A
WHERE
    YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
;