题解 | 牛客每个人最近的登录日期(三)
牛客每个人最近的登录日期(三)
https://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
select round(sum(if(date_add(t.date,interval 1 day ) = l2.date ,1,0))/count(distinct t.user_id),3)as p
from (
select user_id, min(date) as date
from login
group by user_id
) as t
join login l2
on t.user_id=l2.user_id
;
查看3道真题和解析