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