题解 | #计算用户的平均次日留存率#
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
SELECT
COUNT(distinct q2.device_id, q2.date) / COUNT(distinct q1.device_id, q1.date) as avg_ret
FROM
question_practice_detail q1
LEFT JOIN question_practice_detail q2 ON q1.device_id = q2.device_id
and datediff (q1.date, q2.date) = 1
查看3道真题和解析