题解 | #每天的日活数及新用户占比#
每天的日活数及新用户占比
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为新用户登记日,若登记日和活跃日相同 则为当日。