题解 | #牛客每个人最近的登录日期(三)#
牛客每个人最近的登录日期(三)
https://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
个人感觉十分的简洁 select round(sum(p1)/count(distinct user_id),3) p from ( select *,if(date=date_add(d1,interval 1 day),1,0) p1 from (select *,first_value(date)over(partition by user_id order by date) d1 from login) lo1 ) lo2;
查看16道真题和解析