题解 | 计算用户的平均次日留存率
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
SELECT
COUNT(DISTINCT t2.device_id, t2.date)/COUNT(DISTINCT t1.device_id, t1.date) AS avg_ret
FROM question_practice_detail t1
LEFT JOIN question_practice_detail t2 ON t1.device_id = t2.device_id
AND DATE_ADD(t1.date, INTERVAL 1 DAY) = t2.date
查看20道真题和解析