题解 | #牛客每个人最近的登录日期(三)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
SELECT u.name AS u_n, pn.date AS date, sum(pn.number)over(partition by u.name order by pn.date) FROM passing_number pn LEFT JOIN user u on u.id = pn.user_id GROUP BY u.name,pn.date ORDER BY pn.date ,u.name
