sql script

select l.date, coalesce(count(user_id),0)
from (select distinct date from login) l left join (select user_id, min(date) as date
      from login
      group by user_id) tmp on l.date=tmp.date
group by date