题解 | 2021年11月每天新用户的次日留存率
2021年11月每天新用户的次日留存率
https://www.nowcoder.com/practice/1fc0e75f07434ef5ba4f1fb2aa83a450
select dt,round(count(t3.uid)/count(t2.uid),2) uv_left_rate from ( (select distinct uid,date(dt) dt from( select uid,min(in_time) dt from tb_user_log group by uid) as t1 where left(dt,7) = '2021-11') as t2 left join (select distinct uid,date(in_time) dt1 from tb_user_log union select distinct uid,date(out_time) dt1 from tb_user_log) as t3 on t2.uid = t3.uid and t3.dt1 = date_add(t2.dt,interval 1 day)) group by t2.dt
这种跨天的题第一次做，学到了
