with t as(select author, substr(end_time,1,7) as yue, if(if_follow = 2,-1,if_follow) as follow from tb_video_info v join tb_user_video_log u on v.video_id = u.video_id where year(start_time)=2021), q as (select author, yue, round(sum(if(follow <> 1,follow,1))/count(1),3) as rate, sum(follow) a...
