题解 | 牛客每个人最近的登录日期(三)
牛客每个人最近的登录日期(三)
https://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
with t1 as (
select user_id, min(date) as first_login
from login
group by user_id
)
select round(
sum(case when login.user_id is not null then 1 else 0 end) / count(1), 3
) as p
from t1 left join login
on t1.user_id=login.user_id and datediff(login.date, first_login)=1
查看17道真题和解析