with tb as( select tag, date(start_time) dt, if_like, if_retweet from tb_user_video_log u join tb_video_info v on u.video_id = v.video_id ) select tag, dt, sum(if_like) sum_like_cnt_7d, max(if_retweet) max_retweet_cnt_7d from (select t1.tag tag, t1.dt dt, t2.dt dt2, sum(t2.if_like) if_like, sum(t2.i...
