自用 select tag ,concat(avg_play_progress,'%') avg_play_progress from( select tag ,round(sum(flag) / sum(duration) * 100,2) avg_play_progress from( select uid ,t1.video_id ,tag ,duration ,if(timestampdiff(second,start_time,end_time) > duration,duration,timestampdiff(second,start_time,end_ti...
