SELECT 
    YEAR_MONTH,
    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 12 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
FROM (
    SELECT 
        -- SALES_DATE,
        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
        -- UPDATED_NO
        -- YEAR_MONTH,
        -- MONTH_AMT,
        -- CUML_AMT,
        -- YEAR_MOVE_AMT
    FROM
        SALES
    WHERE 
        UPDATED_NO IS NULL
    GROUP BY 
        YEAR_MONTH
)