WITH MonthlySales AS (
    SELECT 
        strftime('%Y-%m', SALES_DATE) AS YEAR_MONTH,
        SUM(SALES_AMT) AS MONTH_AMT
    FROM 
        SALES
    WHERE 
        SALES_TYPE = 2 
        AND UPDATED_NO IS NULL
    GROUP BY 
        strftime('%Y-%m', SALES_DATE)
),
CumulativeSales AS (
    SELECT 
        YEAR_MONTH,
        MONTH_AMT,
        SUM(MONTH_AMT) OVER (ORDER BY YEAR_MONTH) AS CUML_AMT
    FROM 
        MonthlySales
),
MovingAnnualTotal AS (
    SELECT 
        C.YEAR_MONTH,
        C.MONTH_AMT,
        C.CUML_AMT,
        C.MONTH_AMT + COALESCE(SUM(C.MONTH_AMT) OVER (ORDER BY C.YEAR_MONTH ROWS BETWEEN 11 PRECEDING AND 1 PRECEDING), 0) AS YEAR_MOVE_AMT
    FROM 
        CumulativeSales C
)

SELECT 
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT,
    YEAR_MOVE_AMT
FROM 
    MovingAnnualTotal
ORDER BY 
    YEAR_MONTH;