SELECT DATE
      
      ,SUM(CASE WHEN DATE=first_login THEN 1
         ELSE 0 END) AS NEW
FROM
(
SELECT *
      ,MIN(DATE) OVER(PARTITION BY user_id ORDER BY DATE) AS first_login
FROM login 
) AS t1
GROUP BY DATE