SQL68 牛客每个人最近的登录日期(三)
牛客每个人最近的登录日期(三)
http://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
select round(count( CASE WHEN datediff(date, nd) = 1 THEN 1 ELSE NULL END) / count(distinct user_id),3)
from
(select distinct user_id, date, min(date) over(partition by user_id) as nd from login) l
