题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select
name u_n,
date,
sum(number) over(partition by user_id order by date)
from login l
left join passing_number p using(user_id,date)
left join user u on l.user_id=u.id
where number is not null
order by date,u_n
/*
u.name u_n,
date,
sum(number) over(partiton by user_id order by date) ps_num
select
u.name u_n,
date,
sum(number) over(partition by user_id order by date)
from passing_number p
left join user u on p.user_id=u.id
order by date,u_n
*/
