牛客sql-计算用户的平均次日留存率
参考大佬题解做一下记录:
https://blog.nowcoder.net/n/fe24f96a26f1437da19e91ab1d035b03?f=comment
https://blog.nowcoder.net/n/dd3d75ce08e3485c95bafe3c23668fc2?f=comment
https://www.runoob.com/sql/sql-dates.html
DATE_ADD(date, interval expr type)
date参数是合法的日期表达式,expr参数是希望添加的时间间隔
SELECT OrderId,DATE_ADD(OrderDate,INTERVAL 45 DAY) AS OrderPayDate
FROM Orders