题解 | #平均播放进度大于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 join tb_video_info using(video_id)
                            group by tag
                            having substring_index(avg_play_progress, '%', 1) > 60
                            order by avg_play_progress desc