with t1 as ( select a.name as u_n, b.date, b.number as ps_num from passing_number as b left join user as a on a.id = b.user_id ) select u_n, date, sum(ps_num) over(partition by u_n order by date) as ps_num from t1 order by date, u_n;