题解 | 牛客每个人最近的登录日期(四)

select
    l2.date,
    count(l1.date1) as new
from
  login as l2
left join 
    (
        select 
            user_id,
            date as date1,
            row_number() over (partition by user_id order by date) as date_rank
        from
            login
    ) as l1
on 
  l2.user_id=l1.user_id and l1.date1=l2.date and l1.date_rank=1
group by 
  l2.date 
order by 
  l2.date