select round(count(distinct t1.user_id)/(select count(distinct user_id) from login) ,3) from login t1 join login t2
on t1.user_id=t2.user_id and t2.date=date_add(t1.date,interval 1 day)