题解 | 计算用户的平均次日留存率
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
select count(distinct b.device_id,b.date)/count(distinct a.device_id,a.date) as avg_ret from question_practice_detail a left join question_practice_detail b on a.device_id=b.device_id and date_add(a.date,interval 1 day)=b.date
查看8道真题和解析
投递字节跳动等公司7个岗位