Practice SQL Window Functions | Xorthax's Trading Post

Tables Used

orders

Column	Type
orderid	bigint
customerid	bigint
orderdate	timestamp without time zone
totalamount	double precision
status	text

Expected Output

Column
customerid
orderid
orderdate
previousorderdate

57. Order Histories, One Step Back

List each order along with the date of the previous one placed by the same customer.

Xorthax wants to analyze customers' order patterns by looking at their previous orders. Write a query to display the current order and the previous order date for every customer.

Write Your Query