题解 | 平均播放进度大于60%的视频类别
平均播放进度大于60%的视频类别
https://www.nowcoder.com/practice/c60242566ad94bc29959de0cdc6d95ef
with t as(
select
i.tag,
case
when timestampdiff(second,p.start_time,p.end_time)*100/i.duration>=100
then 100
else timestampdiff(second,p.start_time,p.end_time)*100/i.duration
end as progress
from
tb_video_info i inner join tb_user_video_log p using(video_id))
select
tag,
concat(round(avg(progress),2),'%') as avg_play_progress
from
t
group by
tag
having
avg_play_progress>60.00
order by
avg_play_progress desc
查看24道真题和解析