select author, date_format(end_time,'%Y-%m') month, round(sum(case when if_follow = 2 then -1 else if_follow end )/count(if_follow),3) fans_growth_rate, sum(sum(case when if_follow = 2 then -1 else if_follow end)) over(partition by author order by date_format(end_time,'%Y-%m') rows between unbounded preceding and current row) total_fans from tb_video_info s1 left join tb_user_video_log s2 using(video_id) where year(end_time) = 2021 and s2.id is not null group by 1,2 order by 1,2 哥们我这个和你的有啥区别，凭啥你能过