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 a...