题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
SELECT
U.name u_n,P.`date`
# ,SUM(P.number) ps_num
,SUM(P.number) OVER(PARTITION BY P.user_id,U.name ORDER BY P.`date`) ps_num
FROM passing_number P
LEFT JOIN user U ON P.user_id = U.id
# GROUP BY P.user_id,U.name,P.`date`
ORDER BY P.`date`,U.name
;