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
nexttransactionid
nexttransactionamount

55. Future Funds Forecast

For every transaction, show the second upcoming purchase for that customer if available.

The accounting team at Xorthax's trading post is forecasting customer activity. Write a query to show each transaction along with the ID and amount of the customer's second upcoming transaction, if one exists.

Write Your Query