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

transaction

Column	Type
transactionid	bigint
orderid	double precision
customerid	double precision
supplierid	double precision
transactiontype	text
amount	double precision
currencyid	bigint
transactiondate	text
paymentmethod	text
description	text
status	text
createdat	text
updatedat	text

Expected Output

Column
customerid
transactionid
totalamount
previoustransactionid
previoustransactionamount

59. Two Transactions Ago...

Display each transaction alongside the previous two for that customer.

The accounting team wants to analyze previous transactions. Write a query to display the transaction ID, amount, and details of the previous two transactions for each customer.

Write Your Query