select round(sum(t)/count(*),3) from (select user_id,if(FIND_IN_SET(date_add(min(date),interval 1 day),group_concat(date)),1,0) t from login group by user_id) a
select round(sum(t)/count(*),3) from (select user_id,if(FIND_IN_SET(date_add(min(date),interval 1 day),group_concat(date)),1,0) t from login group by user_id) a
牛客博客，记录你的成长
京公网安备 11010502036488号