题解 | 每类视频近一个月的转发量/率
每类视频近一个月的转发量/率
https://www.nowcoder.com/practice/a78cf92c11e0421abf93762d25c3bfad
select tag,sum(if_retweet) retweet_cnt,round(sum(if_retweet)/count(1),3) retweet_rate from tb_user_video_log tuvi join tb_video_info tvi on tuvi.video_id = tvi.video_id where date(start_time) >= date_sub(date((select max(start_time) from tb_user_video_log)),interval 29 day) group by tag order by retweet_rate desc
查看1道真题和解析
