select tag ,concat(round(sum(if(ts>duration,duration,ts))/sum(duration) * 100,2),'%') as avg_play_progress from ( select * ,timestampdiff(second,start_time,end_time) ts from tb_user_video_log # where left(start_time,4) = 2021 and left(end_time,4) = 2021 ) a left join ( select * from tb_video_info...
