select tag,
concat(round(avg(case when timestampdiff(second,tu.start_time,tu.end_time)>tv.duration then 1 else timestampdiff(second,tu.start_time,tu.end_time)/tv.duration end)*100,2),'%')as avg_play_progress
from tb_user_video_log tu
join tb_video_info tv
on tu.video_id = tv.video_id
group by tag
having avg_play_progress >'60.00%'
order by avg_play_progress desc

易错点avg_play_progress >'60.00%'