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

select tag, concat(round(avg(if(vt >= duration, 1, vt / duration)) * 100, 2), '%') as avg_plag_progress
from (select timestampdiff(second, start_time, end_time) as vt, duration, tag
      from tb_user_video_log tuvl
               join tb_video_info t on tuvl.video_id = t.video_id) a
group by tag
having avg(if(vt >= duration, 1, vt / duration)) >= 0.6
order by avg_plag_progress desc;