select name, date, sum(sump) over (partition by name order by date) as ps_num from (select u.name, p.date, sum(p.number) as sump from login l join passing_number p on l.user_id = p.user_id and l.date = p.date join user u on p.user_id = u.id group by p.user_id, p.date order by p.date, u.name) temp order by date, name

京公网安备 11010502036488号