SELECT tvi.tag, CONCAT (ROUND (AVG (IF (TIMESTAMPDIFF(SECOND,start_time,end_time)>tvi.duration,1, TIMESTAMPDIFF(SECOND,start_time,end_time)/tvi.duration) )*100,2 ),"%" ) AS avg_plg_progress FROM tb_user_video_log tul LEFT JOIN tb_video_info tvi ON tul.video_id=tvi.video_id GROUP BY tvi....