SELECT t2.video_id , round(sum(t2.isOver)/count(t2.video_id),3) `avg` FROM ( select t.video_id, t.start_time, t.end_time, tvi.duration, case when (t.end_time - t.start_time) >= tvi.duration then 1 when (t.end_time - t.start_time) < tvi.duration then 0 end `isOver` from tb_user_video_log as t j...
