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_user_video_log uv left join tb_video_info v on uv.video_id = v.video_id group by tag having left(avg...