在SQL Server上显示非零值

Question

请查询如何使所有日期在我的查询中显示在SQL Server上。我试图生成_系列，但正在努力努力将其拟合：以下查询中的代码。

WITH 
    cte_data AS (
        SELECT
            customer_id,
            FORMAT(event_time,'yyyy-MM') as _month,
            'eventtype1' AS source
        FROM Pay.Money
        UNION 
        SELECT
            customer_id,
            FORMAT(event_time,'yyyy-MM') as _month,
            'eventtype2' AS source
        FROM Pay.Send)

SELECT
    _month,
    COUNT(customer_id) AS active_customer
FROM(
    SELECT 
        customer_id,
        _month,
        _no
    FROM(    
        SELECT
            customer_id,
            _month,
            count(customer_id) AS _no
        FROM cte_data
        GROUP BY
            _month,
            customer_id)l
    WHERE _no>2)j
GROUP BY _month

出现的数据显示了我想要的东西，但我想显示数月的0个值，而这些值当前没有数据，

我想要的是

10-2021 5
12-2021 9
02-2022  2

我想要的

10-2021 5
11-2021 0
12-2021 9
01-2022 0
02-2022 2