select tag, concat(avg_play_progress,'%') as avg_play_progress from( select tag, round(avg( case when timestampdiff(second, start_time, end_time) > duration then 100 else timestampdiff(second, start_time, end_time) /duration*100 end), 2) as ...