SELECT M.tag, concat( cast( ( sum( realTime ) / sum( M.duration ) * 100 ) AS DECIMAL ( 10, 2 ) ), "%" ) as avg_play_progress FROM ( SELECT tv.tag AS tag, tv.video_id AS video_id, LEAST( TIMESTAMPDIFF( SECOND, tu.start_time, tu.end_time ), tv.duration ) AS realTime, tv.duration FR...