题解 | #2021年11月每天新用户的次日留存率#
2021年11月每天新用户的次日留存率
https://www.nowcoder.com/practice/1fc0e75f07434ef5ba4f1fb2aa83a450
很久没遇到这么恶心的题了，到处是坑，这要真的笔试得调代码调到崩溃。。。
select t1.in_time dt,round(count(distinct t2.uid)/count(distinct t1.uid),2) from
(select * from
(select uid,min(date(in_time)) in_time,min(date(out_time)) out_time from tb_user_log
group by uid
order by in_time,out_time) t0
where date_format(in_time,'%Y%m') = '202111') t1
left join
(select uid,date(in_time) in_time,date(out_time) out_time from tb_user_log) t2
on (t1.uid = t2.uid and t2.in_time = date_add(t1.in_time,interval 1 day)) or (t1.uid = t2.uid and t1.in_time = t2.in_time and t2.out_time = date_add(t1.in_time,interval 1 day))
group by dt
order by dt
投递亚信科技（中国）有限公司等公司7个岗位 >