题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
SELECT u.`name` u_n,p.date `date`, SUM(number) over(PARTITION by u.`name` ORDER BY p.date) FROM login l JOIN passing_number p ON l.user_id = p.user_id AND l.date = p.date JOIN `user` u ON l.user_id = u.id ORDER BY p.date,u.`name`;