题解 | #2021年11月每天新用户的次日留存率#
2021年11月每天新用户的次日留存率
https://www.nowcoder.com/practice/1fc0e75f07434ef5ba4f1fb2aa83a450
select dt1,round(count(dt2)/count(dt1),2) from (select uid,min(date(in_time)) dt1 from tb_user_log group by uid)t1 left join (select uid,date(in_time) dt2 from tb_user_log union select uid,date(out_time) from tb_user_log)t2 on t1.uid=t2.uid and dt1=date_sub(dt2,INTERVAL 1 day) where date_format(dt1,'%Y-%m')='2021-11' group by dt1 order by dt1
查看2道真题和解析