//本周回流用户数=本周用户活跃数-本周新增用户数-上周活跃用户数
一旦遇到减法问题就使用left join就对了
insert into table ads_back_count
select
“2019-12-20”,
concat(date_add(next_day(“2019-12-20″,”MO”),-7),”_”,date_add(next_day(“2019-12-20″,”MO”),-1)),
count(*)
from
select t1.mid_id
from
(
(select mid_id from