select t3.tag, concat(round(sum(x2) / count(*), 2), '%') avg_play_progress from ( select t1.uid, t1.video_id, TIMESTAMPDIFF(SECOND, t1.start_time, t1.end_time) x1, t2.video_id video_id2, &...