题解 | #每类视频近一个月的转发量/率#
每类视频近一个月的转发量/率
https://www.nowcoder.com/practice/a78cf92c11e0421abf93762d25c3bfad
select t2.tag, sum(if(t1.if_retweet=1,1,0)) as retweet_cut, round(sum(if(t1.if_retweet=1,1,0))/count(*),3) as retweet_rate from tb_user_video_log t1 left join tb_video_info t2 on t1.video_id=t2.video_id where datediff((select max(start_time) from tb_user_video_log),t1.start_time)<=29 group by t2.tag order by retweet_rate desc
