题解 | 计算用户的平均次日留存率
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
with temp
as (
select device_id,date from question_practice_detail
group by 1,2
)
select count(b.device_id)/count(a.device_id) as avg_ret
from
temp a left join temp b
on a.device_id = b.device_id
and a.date = date_sub(b.date,interval 1 day)
字节跳动公司福利 1004人发布
