select round(count(login.date)/count(1),3)
from(
    select user_id,min(date) date from login
group by user_id
)t1 left join login on t1.user_id = login.user_id and datediff(t1.date,login.date)=-1