题解 | 牛客每个人最近的登录日期(三)
牛客每个人最近的登录日期(三)
https://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
select
round(sum(if(login.date is not null,1,0))/count(t1.user_id),3)
from
(
select
user_id,
min(date) first_date,
date_add(min(date),interval 1 day) second_date
from
login
group by
user_id
) as t1
left join login on t1.user_id = login.user_id
and login.date = t1.second_date
对比了一下评论区的感觉写的有些复杂了emm
曼迪匹艾公司福利 135人发布
