select * from
(select tag,
left(start_time,10) as dt,
sum(sum(if_like))over(partition by tag order by left(start_time,10) rows 6 preceding) as sum_like_cnt_7d,
max(sum(if_retweet))over(partition by tag order by left(start_time,10) rows 6 preceding) as max_retweet_cnt_7d 
from tb_user_video_log
join tb_video_info using (video_id)
where year(start_time)=2021
group by tag,dt) a
where dt between '2021-10-01' AND '2021-10-03'
order by tag desc ,dt