题解 | 各个视频的平均完播率
各个视频的平均完播率
https://www.nowcoder.com/practice/96263162f69a48df9d84a93c71045753
SELECT
v.video_id,
ROUND(IFNULL(SUM(IF(TIMESTAMPDIFF(SECOND, start_time, end_time) >= duration, 1,0))/COUNT(*), 0), 3) release_time
FROM tb_user_video_log u
JOIN tb_video_info v ON u.video_id = v.video_id
WHERE YEAR(start_time) = 2021
GROUP BY v.video_id
ORDER BY release_time DESC
拼多多集团-PDD成长空间 997人发布