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

select distinct date,
sum(case when date = first then 1 else 0 end ) as new
from login l
left join (
    select user_id,min(date) as first from login group by user_id
) t
on l.user_id = t.user_id
group by date
order by date