sql计算周月同比

方法一 ：当面对全量表，使用自关联 --笛卡尔积
先看一下笛卡尔积的结果

首先看一下全量表的明细数据

对明细数据进行聚合

select
*
from
(    select count(*) as cnt,app_id,down_date
     from dwd_hispace_down_ds 
     group by app_id,down_date) a
left join
(    select count(*) as cnt,app_id,down_date
     from dwd_hispace_down_ds 
     group by app_id,down_date) b
on a.app_id=b.app_id

select
a.down_date
,a.app_id
,sum(case when a.down_date - b.down_date=7 
 then a.cnt/b.cnt else 0