2023-05-26 14:29 深圳大学 数据分析师
关注
select
count(u2.date) /count(u1.date )
from
(select distinct device_id, date from question_practice_detail) as u1
left join (select distinct device_id, date from question_practice_detail) as u2
on (u1.device_id = u2.device_id) and (date_add(u1.date,interval 1 day)=u2.date)
count(u2.date) /count(u1.date )
from
(select distinct device_id, date from question_practice_detail) as u1
left join (select distinct device_id, date from question_practice_detail) as u2
on (u1.device_id = u2.device_id) and (date_add(u1.date,interval 1 day)=u2.date)
「求助大佬帮看看这道算法题吧！」题目：现在运营想要查看用户在某天刷题后第二天还会再来刷题的平均概率。请你取出相应数据。 示例：question_practice_detail id devic...
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2Fpractice%2F126083961ae0415fbde061d7ebbde453
全部评论
相关推荐
llayy：别急，现在基本上都是学历高（指92本硕或者只有9）+实习的人在卷然后泡池子，秋招可以慢慢来，有大厂实习会有面试机会+offer
投递字节跳动等公司10个岗位 点赞 评论 收藏
分享
