题解 | #每类视频近一个月的转发量/率#
每类视频近一个月的转发量/率
https://www.nowcoder.com/practice/a78cf92c11e0421abf93762d25c3bfad
SELECT tag, sum(if_retweet) as retweet_cut, FORMAT(sum(if_retweet)/count(*),3) AS retweet_rate
FROM tb_user_video_log a
join tb_video_info b ON a.video_id=b.video_id
WHERE datediff('2021-10-02 00:00:00',start_time)<=30
GROUP BY tag
ORDER BY retweet_rate desc
投递hulu等公司7个岗位
，现在知道急了，而且你这个简历完全可以写成一页，劣势太大了，建议转测试