题解 | #各个视频的平均完播率#
各个视频的平均完播率
https://www.nowcoder.com/practice/96263162f69a48df9d84a93c71045753
select b2.video_id,round(sum(if(end_time-start_time>=duration,1,0))/count(b1.video_id),3)'完播率' from tb_user_video_log b1 inner join tb_video_info b2 on b1.video_id=b2.video_id where year(start_time)=2021 group by video_id order by round(sum(if(end_time-start_time>=duration,1,0))/count(b1.video_id),3) desc
查看4道真题和解析