select round(count(l.date) / count(*),3) as p from login as l right join ( select user_id ,min(date) first_dt from login group by user_id ) as t1 on l.date = date_add(t1.first_dt,interval 1 day) and l.user_id = t1.us...