select u.name u_n,p.date date, sum(p.number) over (partition by u.name rows between unbounded preceding and current row) num from login l join passing_number p on l.user_id=p.user_id and l.date=p.date JOIN user u on l.user_id=u.id order by p.date,u.name ; select u.name u_n,p.date date, sum(p.number) over (partition by u.name order by p.date) num from passing_number p JOIN user u on p.user_id=u.id order by p.date,u.name ;