待编辑

代码

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 tbu
inner join tb_video_info as tbv
on tbu.video_id = tbv.video_id
group by tag
having replace(avg_play_progress,'%','') > 60
order by avg_play_progress desc