题解 | #牛客每个人最近的登录日期(三)#
牛客每个人最近的登录日期(三)
https://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
用临时表可以解决但是牛客报错
create temporary table next_day_updated
select login.user_id,res.new_user_date,min(login.date)as new_user_next_day
from ( select user_id, min(date)as new_user_date from login group by 1 )as res
left join login
on login.user_id= res. user_id
and login.date>res.new_user_date
group by 1,2;
select count(distinct new_user_next_day)/ count(distinct new_user_date)
from next_day_updated
，白菜就是我的天花板