题解 | #日活与每日次日留存率#
日活与每日次日留存率
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;
查看29道真题和解析
