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