题解 | 每类视频近一个月的转发量/率
每类视频近一个月的转发量/率
https://www.nowcoder.com/practice/a78cf92c11e0421abf93762d25c3bfad
SELECT
tag,
SUM(if_retweet) retweet_cnt,
ROUND(IFNULL(SUM(if_retweet)/COUNT(*), 0), 3) retweet_rate
FROM tb_user_video_log u
JOIN tb_video_info v ON v.video_Id = u.video_id
WHERE DATEDIFF((SELECT MAX(start_time) FROM tb_user_video_log), start_time) BETWEEN 0 AND 29
GROUP BY tag
ORDER BY retweet_rate DESC
