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

SELECT A.MONTHLY AS "YM",
COALESCE((SELECT (SUM(B.NEW_MRR + B.EXPANSION_MRR - B.DOWNGRADE_MRR - B.CHURN_MRR)) FROM MRR_DATA AS B WHERE A.MONTHLY > B.MONTHLY AND NOT EXISTS(SELECT calendar.MONTHLY FROM calendar WHERE B.MONTHLY<=calendar.MONTHLY AND A.MONTHLY>=calendar.MONTHLY EXCEPT SELECT C.MONTHLY FROM MRR_DATA AS C)),0) AS "MRR" FROM MRR_DATA AS A ORDER BY MONTHLY;