The Next Order Countdown
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
orderdate
nextorderdate

53. The Next Order Countdown

Show each customer's order along with the date of their next one, if it exists.

Xorthax wants to understand the order patterns of his customers. Write a query to display each customer's Order ID, the date of that order, and the date of their next order, if it exists.
Write Your Query