select ti.tag, concat(round(avg(     if(timestampdiff(second, tl.start_time, tl.end_time) > ti.duration, 100,        timestampdiff(second, tl.start_time, tl.end_time) / ti.duration*100) ),&nbs...