描述 用户-视频互动表tb_user_video_log iduidvideo_idstart_timeend_timeif_followif_likeif_retweetcomment_id110120012021-09-24 10:00:002021-09-24 10:00:20110NULL210520022021-09-25 11:00:002021-09-25 11:00:300

国庆期间每类视频点赞量和转发量_牛客题霸_牛客网 select *from(select tag,dt,sum(单日点赞量)over(partition by tag order by dt rows between 6 preceding and 0 following),max(单日转发量)over(partition by tag order by dt rows between