select tag, concat(round(avg(least(timestampdiff(second, start_time, end_time)/ duration, 1)) *100, 2), "%") as avg_play_progress from tb_user_video_log a join tb_video_info b on a.video_id = b.video_id group by 1 having avg(timestampdiff(second, start_time, end_time)/ duration) > 0.6 ...