思路:以刷题表为主表连接用户表,sum()over得到每个用户的每日累计刷题数
select
u.name u_n 
,date
,sum(number)over(partition by p.user_id order by date) ps_num
from passing_number p 
left join user u on p.user_id = u.id
order by 2,1