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

select 
  tag,
  concat(round(avg(if(timestampdiff(second,start_time,end_time)/duration>1,1,timestampdiff(second,start_time,end_time)/duration)*100),2),'%') as avg_play_progress
from 
  tb_user_video_log as t1
join 
  tb_video_info as t2
on 
  t1.video_id=t2.video_id
group by 
  tag
having
  avg_play_progress>60
order by 
  avg_play_progress desc;