题解 | #每类视频近一个月的转发量/率#
每类视频近一个月的转发量/率
http://www.nowcoder.com/practice/a78cf92c11e0421abf93762d25c3bfad
select i.tag, sum(l.if_retweet) retweet_cut, round(sum(l.if_retweet)/count(i.tag),3) retweet_rate
from tb_user_video_log l left join tb_video_info i on l.video_id = i.video_id
where DATEDIFF(DATE((select max(start_time) FROM tb_user_video_log)), DATE(l.start_time)) <= 29
group by i.tag order by retweet_rate desc
