# SELECT # author, # DATE_FORMAT(lo.start_time,'%Y-%m') AS month, # ROUND( # (SUM(IF(if_follow = '1',1,0)) - SUM(IF(if_follow = '2',1,0)))/ # COUNT(*) # , 3)AS fans_growth_rate, # SUM(IF(if_follow = '1',1,0))AS total_fans # FROM tb_user_video_log lo # LEFT J...