WITH SALES_PER_MONTH AS (
    SELECT
        CAST(STRFTIME('%Y', SALES_DATE) AS INTEGER) * 12 +
        CAST(STRFTIME('%m', SALES_DATE) AS INTEGER) AS MONTH,
        STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH,
        SUM(SALES_AMT) AS MONTH_AMT
    FROM
        SALES
    WHERE
        UPDATED_NO IS NULL
    GROUP BY
        YEAR_MONTH
    ORDER BY
        YEAR_MONTH ASC
)
SELECT
    SALES_PER_MONTH.YEAR_MONTH,
    SALES_PER_MONTH.MONTH_AMT,
    (
        SELECT
            SUM(TARGET_MONTH.MONTH_AMT) AS CUML_AMT
        FROM
            SALES_PER_MONTH AS TARGET_MONTH
        WHERE
            TARGET_MONTH.YEAR_MONTH >= '2023-01' AND
            TARGET_MONTH.MONTH <= SALES_PER_MONTH.MONTH
    ) AS CUML_AMT,
    (
        SELECT
            SUM(TARGET_MONTH.MONTH_AMT) AS YEAR_MOVE_AMT
        FROM
            SALES_PER_MONTH AS TARGET_MONTH
        WHERE
            TARGET_MONTH.MONTH - SALES_PER_MONTH.MONTH BETWEEN -11 AND 0
    ) AS YEAR_MOVE_AMT
FROM
    SALES_PER_MONTH
WHERE
    SALES_PER_MONTH.YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
ORDER BY
    SALES_PER_MONTH.YEAR_MONTH ASC