select info1.tag, concat(round(avg(a.play_progress)*100,2),'%') avg_play_progress from (select log.uid,log.video_id, if(TIMESTAMPDIFF(SECOND,log.start_time,log.end_time)>=info.duration,1,TIMESTAMPDIFF(SECOND,log.start_time,log.end_time)/info.duration) play_progress &nbs...