select * from (select tag,date(start_time)dt, sum(sum(if_like)) over(PARTITION BY tag ORDER BY date(start_time) DESC ROWS BETWEEN CURRENT ROW AND 6 FOLLOWING) sum_like_cnt_7d, max(sum(if_retweet)) over(partition by tag order by date(start_time) desc rows between current row and 6 following) max_retweet_cnt_7d from tb_user_video_log left join tb_video_info using(video_id) group by tag,date(start_time) order by date(start_time) desc)a where dt between "2021-10-01" and "2021-10-03" order by tag desc,dt;