SELECT author, date_format (start_time, '%Y-%m') month, round( sum( case when if_follow = 1 then 1 when if_follow = 2 then -1 else 0 end ) / count(author), 3 ) fans_growth_rate, sum( sum( case when if_follow = 1 then 1 when if_follow = 2 then -1 else 0 end ) ) over ( partition by author order by dat...