with aa as( select a.video_id, count(case when timestampdiff(second,start_time,end_time) >= duration then 1 #这块要用case when,因为直接比大小,出来的正确为1,错误为0 不是null,还是会被count进去 &nb...