题目
解答
知识补充
代码
新登录用户的次日成功的留存率:(第一天登录的新用户并且第二天也登录的用户)/(总用户)
select
round(count(distinct user_id)*1.0/(select count(distinct user_id) from login) ,3)
from login
where (user_id,date)
in (select user_id,date_add(min(date),interval 1 day) from login group by user_id)
select round(count(distinct l2.user_id)/(select count(distinct user_id) from login),3)
from (select user_id,date,date_add(date,interval 1 day) as add_date
from login ) l1
left join login l2
on l1.user_id = l2.user_id
and l1.add_date = l2.date
;