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

select tag,concat(round(100*avg(least(ifnull(timestampdiff(second,l.start_time,l.end_time),0)/v.duration,1)),2),'%') avg_play_process
from tb_user_video_log l
right join
tb_video_info v
on l.video_id = v.video_id
group by tag
having avg(least(ifnull(timestampdiff(second,l.start_time,l.end_time),0)/v.duration,1))>0.6
order by avg_play_process desc;