5-Transaction Tally Tracker
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
orderdate
totalamount
rollingtotal
rank

27. 5-Transaction Tally Tracker

Calculate a rolling sum of each customer's last 5 orders and rank them accordingly.

Xorthax wants to analyze the transaction volume for each customer. Write a query to rank each order within its customer's history based on the rolling sum of the last 5 transactions.
Write Your Query