题解 | 各个视频的平均完播率
各个视频的平均完播率
https://www.nowcoder.com/practice/96263162f69a48df9d84a93c71045753
select info.video_id, round(sum(case when timestampdiff(second, log.start_time, log.end_time)>=info.duration then 1 else 0 end )/count(*),3) avg_comp_play_rate # case when 后面不用加括号，不然会报错 from tb_user_video_log log left join tb_video_info info on log.video_id=info.video_id where log.end_time like '2021-%' group by info.video_id order by avg_comp_play_rate DESC
