select
date,sum(case when date=d then 1 else 0 end)
from
(select * ,min(date) over(partition by user_id) d from login) as a
group by date
order by date