select u.name,p.date,sum(p.number)over(partition by p.user_id order by date) from passing_number p join user u on p.user_id=u.id order by p.date,u.name;