题解 | #每类视频近一个月的转发量/率#
每类视频近一个月的转发量/率
http://www.nowcoder.com/practice/a78cf92c11e0421abf93762d25c3bfad
from tb_video_info v inner join tb_user_video_log u
on v.video_id = u.video_id
where timestampdiff(day,date(u.start_time),date((select max(start_time) from tb_user_video_log)))<=29
group by v.tag
order by retweet_rate desc
投递影石Insta360等公司10个岗位