题解 | 计算用户的平均次日留存率
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
select round(count(distinct q2.device_id, q2.date) / count(distinct q1.device_id, q1.date), 4) as avg_ret from question_practice_detail q1 left join question_practice_detail q2 on q1.device_id = q2.device_id and date_add(q1.date, interval 1 day) = q2.date;
查看20道真题和解析