SUM 聚合窗口函数时对author PARTITION BY,对month ORDER BY ,算的是每个月的累积粉丝,不是全部日期的累积粉丝 WITH t_fan AS (SELECT b.author,DATE_FORMAT(a.start_time,'%Y-%m') AS month, ROUND((COUNT(IF(if_follow=1,1,NULL)) - COUNT(IF(if_follow=2,1,NULL)) )/COUNT(*),3) AS fans_growth_rate, COUNT(IF(if_follow=1,1,NULL))-COUNT(IF(if_follow...