SELECT 
S1.YEAR_MONTH,
SUM(S1.SALES_AMT) AS MONTH_AMT,
(
    SELECT SUM(S2.SALES_AMT) 
    FROM SALES S2
    WHERE SUBSTRING(S2.SALES_DATE,0,8) <= S1.YEAR_MONTH
    AND UPDATED_NO IS NULL
    AND SUBSTRING(S2.SALES_DATE,0,8) BETWEEN '2023-01' AND '2023-12'
) CUML_AMT,
(
    SELECT SUM(S3.SALES_AMT) 
    FROM SALES S3
    WHERE 
    S3.UPDATED_NO IS NULL
    AND SUBSTRING(S3.SALES_DATE,0,8) BETWEEN SUBSTRING(date(S1.SALES_DATE, '-11 months'),0,8) AND S1.YEAR_MONTH
) YEAR_MOVE_AMT
FROM
(
SELECT
SALES_DATE,
SUBSTRING(SALES_DATE,0,8) AS YEAR_MONTH,
SALES_AMT
FROM
SALES
WHERE
UPDATED_NO IS NULL
) S1
WHERE S1.YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
GROUP BY S1.YEAR_MONTH