题解 | 计算用户的平均次日留存率
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
select avg(stay) as avg_ret
from (
select device_id, date,
if(date_add(date, interval 1 day) = lead(date) over(partition by device_id order by date), 1, 0) as stay
from question_practice_detail
group by device_id, date
) as qpd2
查看24道真题和解析