select video_id AS avg_comp_play_rate, round(avg((end_time - start_time) >= (select vi.duration from tb_video_info vi where vi.video_id = tb_user_video_log.video_id)), 3) AS avg_comp_play_rate from tb_user_video_log where year(start_time) = 2021 group by video_id order by avg_comp_play_rate descselect video_id AS avg_comp_play_rate, round(avg((end_time - start_time) >= (select vi.duration from tb_video_info vi where vi.video_id = tb_user_video_log.video_id)), 3) AS avg_comp_play_rate from tb_user_video_log where year(start_time) = 2021 group by video_id order by avg_comp_play_rate desc