题解 | #每类视频近一个月的转发量/率#

select tag, retweet_cut, retweet_rate
from
(select tag, round(sum(if_retweet),3) as retweet_cut, round(sum(if_retweet)/count(*),3) as retweet_rate
from tb_user_video_log left join tb_video_info on tb_user_video_log.video_id = tb_video_info.video_id
where timestampdiff(day, end_time, (select max(end_time) from tb_user_video_log)) < 30
group by tag) as t1
order by retweet_rate desc