题解 | #日活与每日次日留存率#
日活与每日次日留存率
https://www.nowcoder.com/practice/18b168ada98d4bdb9108444443cea7d3
select a.visit_date, count(*) dau, count(b.visit_date)/count(*) next_day_per from user_visit_log a left join user_visit_log b on a.id = b.id and timestampdiff(day,a.visit_date,b.visit_date)=1 group by a.visit_date;
木的办法， 以后越来越差，还是家附近宅着吧，毕业的人越来越多，岗位都提供不出来，经济又过了人口红利期