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

select u1.visit_date,count(u1.id) dau,
        count(u2.visit_date)/count(u1.id) next_day_per
from user_visit_log u1 
left join user_visit_log u2
on u1.id=u2.id 
and u2.visit_date=adddate(u1.visit_date,interval 1 day)
group by u1.visit_date;