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

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

还是需要熟悉一下时间相关的函数，卡了好久。