#先查出每条互动记录的播放进度 #在按tag分组 查平均播放进度 select t4.tag , concat(round(avg(t3.bofangjindu),2),"%") avg_play_progress from ( select t1.video_id , (if(((hour(timediff(t1.end_time,t1.start_time))*60*60+min...