题解 | #每天的日活数及新用户占比#

每天的日活数及新用户占比

https://www.nowcoder.com/practice/dbbc9b03794a48f6b34f1131b1a903eb

with t1 as 
(select uid,date(in_time)as dt,date(min(in_time)over(partition by uid)) as min_dt,
case when date(in_time)=date(min(in_time)over(partition by uid)) then 1 else 0 end as new
from tb_user_log
UNION
select uid,date(out_time)as dt,date(min(in_time)over(partition by uid)) as min_dt,
case when date(out_time)=date(min(in_time)over(partition by uid)) then 1 else 0 end as new
from tb_user_log
order by uid, dt
)

select dt,count(*) as dau,round(sum(new)/count(*),2) as uv_new_ratio
from t1 group by dt

全部评论

相关推荐

不愿透露姓名的神秘牛友
07-04 18:25
点赞 评论 收藏
分享
06-02 15:17
门头沟学院 Java
心爱的idea:怎么会呢 应该是打招呼有问题 问就说实习6个月全国可飞随时到岗
点赞 评论 收藏
分享
这算盘打的
程序员小白条:都这样的,都是潜规则,你自己说可以实习一年就行了,实习可以随便跑路的
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

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