题解 | 问GPT之前先动手画个表格把关系梳理清楚
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select name u_n,lo.date date,sum(number)over(partition by lo.user_id order by lo.date) ps_num from login lo right join passing_number pn on lo.user_id=pn.user_id and lo.date=pn.date left join user u on u.id=pn.user_id order by lo.date,name