SELECT 
    YEAR_MONTH,
    -- ym_idx,
    MONTH_AMT,
    SUM(MONTH_AMT) OVER(ORDER BY ym_idx ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS CUML_AMT,
    SUM(MONTH_AMT) OVER(ORDER BY ym_idx RANGE BETWEEN 11 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
FROM (
    SELECT 
        DATE(SALES_DATE, "START OF MONTH") AS YEAR_MONTH,
        CAST(STRFTIME("%Y", DATE(SALES_DATE, "START OF MONTH")) AS INT) * 12 + CAST(STRFTIME("%m", DATE(SALES_DATE, "START OF MONTH")) AS INT) AS ym_idx,
        SUM(SALES_AMT) AS MONTH_AMT
    FROM
        SALES
    WHERE 
        UPDATED_NO IS NULL
        AND YEAR_MONTH >= "2023-01-01"
    GROUP BY 
        YEAR_MONTH
)
ORDER BY 
    YEAR_MONTH ASC