如何在Azure Synapse专用SQL池生成按年月拆分的客户收入表？

背景信息 #

客户表存储了每位客户的信息、订阅类型，以及基于订阅类型的会员开始日期、下次付款日期等数据，表结构及示例数据如下：
客户表：

需求 #

需在Azure Synapse专用SQL池中创建名为Revenue的表，按客户、年度、月度拆分展示确认收入与递延收入，目标表结构及示例数据如下：
收入表（Revenue Table）：

当前进展与问题 #

已编写单个客户的收入计算脚本（以cus_OzcGFMWjj7e6wf为例），代码如下：

declare @Membership_StartDate date;
declare @Membership_EndDate date;
declare @Gross INT;

set @Membership_StartDate = '2023-11-12';
set @Membership_EndDate = '2024-11-12';
set @Gross = 216.000000;

With FirstQuery AS
(
select year(dt) [Year], month(dt) [Month], count(*) NumberofDays
from (select top(datediff(d, dateadd(dd,-1,@Membership_StartDate), dateadd(dd,-1,@Membership_EndDate))) dateadd(d, row_number() over (order by (select null)), dateadd(dd,-1,@Membership_StartDate)) dt
from sys.columns) q
group by year(dt), month(dt)
)   
select Year
    , Jan = MAX(case when Month = 1 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Feb = MAX(case when Month = 2 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Mar = MAX(case when Month = 3 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Apr = MAX(case when Month = 4 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , May = MAX(case when Month = 5 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Jun = MAX(case when Month = 6 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Jul = MAX(case when Month = 7 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Aug = MAX(case when Month = 8 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Sep = MAX(case when Month = 9 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Oct = MAX(case when Month = 10 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Nov = MAX(case when Month = 11 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)
    , Dec = MAX(case when Month = 12 then (1.0*NumberofDays)/(1.0*DATEDIFF(day, @Membership_StartDate, @Membership_EndDate))*(1.0*@Gross) end)    
from FirstQuery
group by Year

请求指导如何将该脚本适配客户表中的所有客户，以生成目标Revenue表。

内容的提问来源于stack exchange，提问作者Vivek