# 粒度-视频# 筛选符合条件的视频,再进行计算with tmp1 as( select max(date(end_time)) max_date from tb_user_video_log),tmp2 as ( select tuvl.video_id ,date(end_time) end_date ,timestampdiff(second, start_time, end_time) time_diff ,if_like ,if_retweet ,duration ,(case when comment_id ...