题解 | #各个视频的平均完播率#

SELECT video_id,round(avg((end_time-start_time) >= duration),3) as avg_comp_play_rate from (

SELECT uid,vid.video_id ,duration,start_time,end_time from tb_user_video_log user join tb_video_info vid on user.video_id = vid.video_id where year(start_time) = '2021') as t1
group by video_id order by avg_comp_play_rate desc

大佬教我做的。新思路