select l.date, ifnull(cast(lead(cnt1) over(order by date)as float)/l.cnt2,0.000) from (select date, sum(case when (login.user_id, login.date) in (select user_id, date(min(date), '+1 day') from login group by user_id) then 1 else 0 end)as cnt1,sum(case when (login.user_id, login.date) in (select user_id, min(date) from login group by user_id) then 1 else 0 end) as cnt2 from login group by date order by date) l