题解 | #计算用户的平均次日留存率#
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
简简单单~
select count(device_id)/(select count(d.device_id) from (select distinct device_id,date from question_practice_detail ) as d) from
(
select device_id,date,date_new,datediff(date_new,date) as gap from
(select device_id,date,lead(date,1,date) over(partition by device_id order by date asc) as date_new
from question_practice_detail
) as a
) as b where gap = 1
