select login_date date,
sum(case when login_date = first_date then 1 else 0 end) new
from (select date login_date,
min(date)over(partition by user_id) first_date
from login) t
group by date
order by date;