输出% 需要用concat(...,'%')和replace(...,'%','')可能存在播放时长大于视频时长的情况,需要用IF(判断语句, 真则a, 假则b)播放时长要以秒为单位,用timestampdiff(second, start,end) select tag, concat( round( avg( if (timestampdiff(second, start_time, end_time)/duration > 1, 100, timestampdiff(second, start_time...