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