select tag,concat(round(avg(t_per)*100,2),'%') avg_play_progress from(     select v.tag,if(timestampdiff(second,u.start_time,u.end_time)>v.duration,                   &nbsp...