为啥我写这个实例不能通过呢？请大佬帮忙看看：select distinct b.video_id, round(sum(if(b.end_time - b.start_time >= a.duration, 1, 0)) / count(b.start_time),3) as avg_comp_play_rate from tb_user_video_log b left join ( select video_id, duration from tb_video_info where video_id in ( select distinct video_id from tb_user_video_log where year(start_time) = 2021 ) )a on a.video_id = b.video_id group by b.video_id order by avg_comp_play_rate desc;