一般的周累计
select
dim1,
dim2,
weekofyear(inc_day) as inc_week,
count(*) as num
from a
group by dim1,dim2,inc_week
递进式每天的周累计
with t1 as (
一般的周累计
select
dim1,
dim2,
weekofyear(inc_day) as inc_week,
count(*) as num
from a
group by dim1,dim2,inc_week
递进式每天的周累计
with t1 as (