题解 | #计算用户的平均次日留存率#
计算用户的平均次日留存率
http://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
select count(distinct device_id,date)/
(select count(distinct device_id,date) from question_practice_detail)
from question_practice_detail
where (device_id,date) in (select device_id,date_add(date,interval 1 DAY) date
from question_practice_detail)
(select count(distinct device_id,date) from question_practice_detail)
from question_practice_detail
where (device_id,date) in (select device_id,date_add(date,interval 1 DAY) date
from question_practice_detail)
投递百度等公司10个岗位
查看3道真题和解析