题解 | #各个视频的平均完播率#
各个视频的平均完播率
https://www.nowcoder.com/practice/96263162f69a48df9d84a93c71045753
-- 简单得有点无聊 select video_id,round(sum(isend)/count(looktime),3) avg_comp_play_rate from ( select video_id, case when tb.duration<=uvl.looktime then 1 else 0 end as isend,uvl.looktime from tb_video_info tb right join( select video_id,end_time-start_time looktime from tb_user_video_log where year(start_time)='2021' ) uvl using(video_id) ) t group by video_id order by 2 desc
腾讯云智研发一面203人在聊
查看6道真题和解析
