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

select tag,CONCAT(round(ls/duration *100,2),'%') as avg_play_progress

from

(

select b.tag,b.duration,

avg(TIMESTAMPDIFF(SECOND,start_time,end_time)) ls

from

tb_user_video_log a

inner join tb_video_info b on a.video_id = b.video_id

where year(start_time) ='2021'

group by b.tag,b.duration

) tmp

where ls/duration>0.6