select tag,concat(round(100*avg(least(ifnull(timestampdiff(second,l.start_time,l.end_time),0)/v.duration,1)),2),'%') avg_play_process from tb_user_video_log l right join tb_video_info v on l.video_id = v.video_id group by tag having avg(least(ifnull(timestampdiff(second,l.start_time,l.end_time),0)/v...