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

select
    l.date,count(distinct m.user_id) as new
from
    login l left join
    (select user_id,min(date) date from login group by user_id) m
on l. date = m.date
group by
    date 
order by
    date