题解 | #计算用户的平均次日留存率#
计算用户的平均次日留存率
http://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
with s as ( select distinct device_id, date from question_practice_detail) select (select count(*) from s where (device_id, date) in (select device_id, date+1 from s))/count(*) from s