题解 | #日活与每日次日留存率#

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;