select date,sum( case when (user_id,date) in (select user_id,min(date) from login group by date) then 1 else 0 end ) as new from login group by date order by date;