题解 | #日活与每日次日留存率#
日活与每日次日留存率
https://www.nowcoder.com/practice/18b168ada98d4bdb9108444443cea7d3
这样写还可以直接加上n日留存率
select a.visit_date, count(distinct a.id) as dau, count(distinct if(datediff(b.visit_date,a.visit_date)=1,b.id,null))/count(distinct a.id) as next_day_per from user_visit_log a left join user_visit_log b on a.id=b.id and datediff(b.visit_date,a.visit_date) >0 group by a.visit_date;