【业务数据处理】截止至当天累计充值数据

select [user_id], [日期],
row_number() over (partition by  [user_id] order by  [日期]  asc) as [第N天登陆],
sum([充值金额]) over (partition by  [user_id] order by  [日期]  asc) as [截止至当天累计充值金额]
from user_行为信息表
where [日期1] > '2020-10-28' and  [user_id] is not null 
order by [user_id],[第N天登陆] desc