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_video_inf...