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

SELECT user.`name` AS u_n, f1.date, f1.ps_num
FROM user,
	(SELECT user_id, date, SUM(number) OVER(PARTITION BY user_id ORDER BY date ASC) AS ps_num FROM passing_number) AS f1
WHERE user.id = f1.user_id
ORDER BY f1.date, user.`name`;