select tag,concat(round(avg(avg_play_progress),2),'%')avg_play_progress
from(
select 
tag,
if(timestampdiff(second,start_time,end_time)/duration>1,100,timestampdiff(second,start_time,end_time)/duration*100)avg_play_progress
from tb_user_video_log a
left join tb_video_info b
on a.video_id=b.video_id)tt
group by tag
having avg(avg_play_progress)>60
order by avg_play_progress desc