题解 | #牛客每个人最近的登录日期(六)#

SELECT  NAME,b.date,SUM(NUMBER) OVER(PARTITION BY NAME ORDER BY c.date) AS ps_num
FROM user AS a LEFT JOIN login AS b
ON a.id = b.user_id
LEFT JOIN passing_number AS c
ON b.user_id = c.user_id AND b.date = c.date
WHERE c.date IS NOT NULL
ORDER BY DATE,NAME