题解 | #查询用户刷题日期和下一次刷题日期#
查询用户刷题日期和下一次刷题日期
https://www.nowcoder.com/practice/fed7ebf4254240fdb6a2c963996ee8ff
SELECT user_id, date, LEAD(date,1,'None') -- 返回当前行后一行数据 OVER(PARTITION BY user_id ORDER BY date) AS nextdate FROM questions_pass_record ORDER BY user_id