题目:请你写出一个sql语句查询刷题信息,包括: 用户的名字,以及截止到某天,累计总共通过了多少题,

并且查询结果先按照日期升序排序,再按照姓名升序排序;

思路:截止到某天累计通过的题数使用sum(number)over(partition by user_id order by date)

使用的函数:sum() over(partition by)

SELECT u.name AS u_n, pn.date, sum(number) over(partition by pn.user_id order by pn.date) FROM passing_number AS pn LEFT OUTER JOIN user AS u ON pn.user_id = u.id ORDER BY date, u.name