WITH RECURSIVE calendar(calendar_date) AS (
    SELECT
        -- ここが始まりの日付
        DATE('2023-01-01') AS calendar_date
    UNION ALL
    -- UNION ALL 以下が再帰処理部分
    SELECT
        DATE(calendar_date, '+1 month') AS calendar_date
    FROM calendar
    WHERE
        -- ここが終わりの日付
        calendar_date < DATE('2023-12-01')
)

-- ここが実際のSELECT文
SELECT strftime('%Y-%m', calendar_date) as YEAR_MONTH,
(select sum(SALES_AMT) from SALES where UPDATED_NO is NULL and strftime('%Y-%m', SALES_DATE) = strftime('%Y-%m', calendar_date)) as MONTH_AMT,
(select sum(SALES_AMT) from SALES where UPDATED_NO is NULL and SALES_DATE >= '2023-01-01' and SALES_DATE < DATE(DATE(calendar_date, '+1 month'), '-1 day')) as CUML_AMT,
(select sum(SALES_AMT) from SALES where UPDATED_NO is NULL and SALES_DATE < DATE(DATE(calendar_date, '+1 month'), '-1 day') and SALES_DATE >= DATE(calendar_date, '-11 month')) as YEAR_MOVE_AMT
FROM calendar;