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

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

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

select a.dt,count(distinct a.uid) dau,round(count(distinct b.uid)/count(distinct a.uid),2)
from 
        (select uid,date(in_time) dt
        from tb_user_log
        union all
        select uid,date(out_time) dt
        from tb_user_log
        group by uid,dt
         ) a
left join
         (select uid,min(date(in_time)) dt
          from tb_user_log
          group by uid
         ) b
on a.uid=b.uid and a.dt=b.dt
group by a.dt
order by a.dt;

union all 不去重,应该需要去重 a表为出入的活跃日, b为新用户登记日,若登记日和活跃日相同 则为当日。

全部评论

相关推荐

嵌入式求职之路:可以看我经验😂,https://www.nowcoder.com/share/jump/73221730841876945
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务