SELECT tp.tag,CONCAT(avg_play_progress, "%") avg_play_progress FROM (SELECT tag, ROUND( AVG(IF( TIMESTAMPDIFF(SECOND, start_time, end_time)>tvi.duration, 1, TIMESTAMPDIFF(SECOND, start_time, end_time)/tvi.duration ) ) *100, 2 ...