select author, month, round(fans_add/num,3) fans_growth_rate, sum(fans_add) over (partition by author order by month) as total_fans from ( select author, date_format(start_time,"%Y-%m") as month, sum( case when if_follow=2 then -1 when if_follow=1...