select round(count(distinct l.user_id)/(select count(distinct user_id) from login),3) p from login l,
(select user_id,DATE_ADD(date,INTERVAL 1 DAY) d from login) new 
where l.user_id=new.user_id and l.date=new.d