题解 | #各个视频的平均完播率#
国庆期间每类视频点赞量和转发量
http://www.nowcoder.com/practice/f90ce4ee521f400db741486209914a11
select * from ( select tag, dt, sum(likes) over ( partition by tag # order by dt rows 6 preceding # ) sum_like_cnt_7d, max(retweets) over ( partition by tag # order by dt rows 6 preceding # ) max_retweet_cnt_7d from ( select tt.tag, date_format(t.start_time, '%Y-%m-%d') dt, sum(if_like) likes, sum(if_retweet) retweets from tb_user_video_log t, tb_video_info tt where t.video_id = tt.video_id group by 1, 2 ) a ) b where dt between '2021-10-01' and '2021-10-03' order by tag desc, dt
我教你****：你好，本人985电子科大在读研一，本科西南大学（211）我在字节跳动实习过。对您的岗位很感兴趣，希望获得一次投递机会。