思路：
①准备一张底表tb3，计算出每天得点赞数、转发数；
②基于tb3用窗口函数计算出每天对应的近一周内点赞、转发数；
③选出需要的时期即可。

with tb3 as(
select tag, date(end_time) dt, sum(if_like) a, sum(if_retweet) b 
from tb_user_video_log tb1 left join tb_video_info tb2 using(video_id)
group by tag, dt)

select * from(
select tag, dt, 
sum(a)over(partition by tag order by dt range interval 6 day preceding) c,
max(b)over(partition by tag order by dt range interval 6 day preceding) d
from tb3) tb4
where dt between '2021-10-01' and '2021-10-03'
order by tag desc, dt