select tag,dt,sum_like_cnt_7d,max_retweet_cnt_7d from( select tag,date(end_time) dt, sum(sum(if_like)) over(partition by author order by date(end_time) rows 6 preceding) as sum_like_cnt_7d, max(sum(if_retweet)) over(partition by author order by date(end_time) rows 6 preceding) as max_retweet_cnt_7d from tb_user_video_log left join tb_video_info using(video_id) group by tag,dt) t1 where dt>='2021-10-01' and dt<='2021-10-03' order by tag desc,dt 请问这样为什么不可以呀