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

select * from(
select 
tag,date(start_time) as dt,
sum(sum(if_like)) over(partition by tag order by date(start_time) rows 6 preceding) as total_like,
max(sum(if_retweet)) over(partition by tag order by date(start_time) rows 6 preceding) as day_retweet
from 
tb_user_video_log t1 left join tb_video_info t2
on t1.video_id=t2.video_id
group by tag,date(start_time))a
where dt between '2021-10-01' and '2021-10-03'
order by tag desc,dt