题解 | #对比一周的播放完成率变化#

对比一周的播放完成率变化

https://www.nowcoder.com/practice/47852dbdf412481198597eaa1505ecd6

with t1 as (select weekth,avg(wbl) as avg_ratio from (select weekth,(case when times>time_len then 1 else times/time_len end) as wbl from(select uid,u.vid,timestampdiff(second,start_time,end_time) as times,time_len,weekday(start_time)+1 as weekth from user_play_log_tb as u left join video_info_tb as v using(vid)) t)k group by weekth)
select t1.weekth,concat(round(100*(avg_ratio1/avg_ratio-1),1),'%') as play_ratio_delta from t1 inner join (select case when weekth=0 then 7 else weekth end as weekth,avg_ratio as avg_ratio1 from (select (weekth-1)%7 as weekth,avg_ratio from t1) t2) t3 using (weekth) order by weekth

全部评论

相关推荐

不愿透露姓名的神秘牛友
07-09 11:15
点赞 评论 收藏
分享
不亏是提前批,神仙打架,鼠鼠不配了
站队站对牛:现在92都报工艺岗了
投递韶音科技等公司7个岗位
点赞 评论 收藏
分享
06-23 11:28
门头沟学院 Java
牛客91966197...:也有可能是点拒绝的时候自动弹的话术
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务