题解 | #平均播放进度大于60%的视频类别#

select
tag,concat(round(avg(if(timestampdiff(second,start_time,end_time)
/duration<=1,timestampdiff(second,start_time,end_time)
/duration,1))*100,2),'%') avg_play_progres
from tb_video_info ti join tb_user_video_log tu on ti.video_id=tu.video_id
group by tag
having left(avg_play_progres,4)>60.00
order by avg_play_progres desc