select
    t1.date,
    sum(if_new) as new
from 
    (select
        l.user_id,
        l.date,
    case
        when row_number() over(partition by l.user_id order by l.date asc)=1
        then 1 else 0
        end as if_new
    from 
        login l
    ) t1
group by 
    t1.date
order by 
    t1.date asc