题解 | 国庆期间每类视频点赞量和转发量

select *
from (select tag,
             dt,
             sum(sl) over (rows between 6 preceding and current row ) as sum_like_cnt_7d,
             max(sr) over (rows between 6 preceding and current row ) as max_retween_cnt_7d
      from (select tag, date(start_time) as dt, sum(if_like) as sl, sum(if_retweet) as sr
            from tb_user_video_log tuvl
                     join tb_video_info t on tuvl.video_id = t.video_id
            group by tag, dt) a
      where dt between '2021-09-25' and '2021-10-03') b
where dt between '2021-10-01' and '2021-10-03'
order by tag desc, dt;