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

select tag,
concat(ROUND(AVG(
            IF(TIMESTAMPDIFF(SECOND, start_time, end_time) > duration, 1,
               TIMESTAMPDIFF(SECOND, start_time, end_time) / duration)
        ) * 100, 2),'%') as avg_play_progress
from tb_user_video_log as A left join tb_video_info as B on A.video_id=B.video_id
group by tag
having avg(TIMESTAMPDIFF(SECOND, start_time, end_time) / duration)>0.6
order by avg_play_progress desc