select tag ,concat(round(avg(if((timestampdiff(second,start_time,end_time))/duration>=1,1 ,(timestampdiff(second,start_time,end_time))/duration) )*100,2),'%') avg_play_progress from tb_user_video_log t1 left join tb_video_info t2 on t1.video_id = t2.video_id group by 1 having avg(if((timestampdif...