select tag,dt,sum_like_cnt_7d,max_retweet_cnt_7d
from
(select tag,dt,
sum(like_cnt) over(partition by tag order by dt rows 6 preceding) as sum_like_cnt_7d,
max(retweet_cnt) over(partition by tag order by dt rows 6 preceding) as max_retweet_cnt_7d
from
    (select tag,date_format(start_time,'%Y-%m-%d') as dt,
    sum(if_like) as like_cnt,sum(if_retweet) as retweet_cnt
    from tb_user_video_log as log
    left join tb_video_info as info
    on log.video_id=info.video_id
    where date(start_time) between '2021-09-25' and '2021-10-03'
    group by tag,dt
     )as t1
 )as t2
where dt between '2021-10-01' and '2021-10-03'
order by tag desc,dt asc