16:28

select video_id,round(avg(result),3) as avg_comp_play_rate from (select tb_user_video_log.id as uid,tb_user_video_log.video_id as video_id , (CASE WHEN TIMESTAMPDIFF(SECOND,start_time,end_time) >= duration then 1 else 0 end) as result from tb_user_video_log inner join tb_video_info on tb_user_video_log.video_id = tb_video_info.video_id where DATE_FORMAT(start_time, "%Y") = "2021")s group by video_id order by avg_comp_play_rate desc