WITH t1 as (SELECT l.user_id as id, p.date as d1,
sum(sum(number)) over (partition by l.user_id order by p.date ROWS between UNBOUNDED PRECEDING and CURRENT ROW) as number
FROM login l
LEFT JOIN passing_number p on l.user_id=p.user_id and l.date=p.date
WHERE p.date is not null
GROUP BY l.user_id,p.date
ORDER BY p.date asc)
SELECT u.name as un, d1 as date, number as ps_num
FROM t1, user u
WHERE t1.id=u.id
ORDER BY date, un asc