SELECT
`user`.name AS name,
t2.`date`,
SUM(t1.number) AS cnt
FROM
passing_number AS t1
JOIN
passing_number AS t2
ON
t1.user_id = t2.user_id
AND
t1.date <= t2.date
LEFT OUTER JOIN
`user`
ON
t2.user_id = `user`.id
GROUP BY
t2.date, t2.user_id
ORDER BY
t2.date ASC , `user`.name ASC

京公网安备 11010502036488号