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
全部评论
相关推荐
点赞 评论 收藏
分享
02-12 20:22
重庆大学 Java
双非后端失败第N人:1. go语言我建议你让ai带着你先把基本语法速通了,然后再去用go重新刷你以前刷过的leetcode,这样熟悉起来很快 2. 直接看你们组go项目,里面用***比较复杂,然后把每一个语法现象都喂给ai,一点点看
字节跳动公司福利 1371人发布 点赞 评论 收藏
分享
点赞 评论 收藏
分享