题解 | #牛客每个人最近的登录日期(三)#
牛客每个人最近的登录日期(三)
https://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
select round(count(distinct l2.user_id)/count(distinct l.user_id),3)p from login l left join (select user_id,date_add(min(date),interval 1 day)d2 from login group by user_id)l2 on l.user_id=l2.user_id and l.date=l2.d2
