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

select b.tag,
concat(round(sum(if(timestampdiff(second,a.start_time,a.end_time)>=b.duration,1,timestampdiff(second,a.start_time,a.end_time)/b.duration))*100/count(b.tag),2),'%') as avg_play_progress
from tb_video_info b right  join tb_user_video_log a using(video_id)
group by b.tag having avg_play_progress>60
order by avg_play_progress desc

"保留百分数小数点后两位