题解 | #牛客每个人最近的登录日期(三)#
牛客每个人最近的登录日期(三)
http://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
select round(avg(m),3) from(
select id1,max((case when id2>=1 then 1 else 0 end)) as m from(
select l1.user_id as id1,l2.user_id as id2
from login l1 left join login l2 on l1.user_id=l2.user_id
and l2.date = adddate(l1.date,interval '1' day)
)as a group by id1
) as b 
查看34道真题和解析
OPPO公司福利 1108人发布