分析: 简单求滚动sum
SELECT
u.NAME AS u_n,
c.NAME AS c_n,
pn.date AS date,
sum( pn.number ) over ( PARTITION BY pn.user_id ORDER BY pn.date ) AS ps_num
FROM
passing_number pn
INNER JOIN USER u ON pn.user_id = u.id
INNER JOIN login l ON pn.user_id = l.user_id
AND pn.date = l.date
INNER JOIN client c ON l.client_id = c.id
ORDER BY
pn.date,
u.NAME