题解 | #计算用户的平均次日留存率#
计算用户的平均次日留存率
https://www.nowcoder.com/practice/126083961ae0415fbde061d7ebbde453
select sum(if(datediff(date_next, `date`)=1, 1, 0))/count(*) from (select device_id, `date`, lead(`date`, 1, '9999-12-31') over (partition by device_id order by `date`) as date_next from (select distinct device_id, `date` from question_practice_detail) a) a1;
开窗函数秒了
投递牛客等公司10个岗位
，现在知道急了，而且你这个简历完全可以写成一页，劣势太大了，建议转测试