# 2021年 有播放记录的 # 每个视频的完播率(三位小数) # 完播率降序排序 with temp as( select log.video_id video_id, round(sum( case when timestampdiff(second,log.start_time,log.end_time) >= video.duration then 1 else 0 end )/count(*),3) avg_comp_play_rate from tb_user_video_log log...