Transaction Percentile Tracker
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
transaction
ColumnType
transactionidbigint
orderiddouble precision
customeriddouble precision
supplieriddouble precision
transactiontypetext
amountdouble precision
currencyidbigint
transactiondatetext
paymentmethodtext
descriptiontext
statustext
createdattext
updatedattext
Expected Output
Column
transactionid
totalamount
percentrank

63. Transaction Percentile Tracker

Evaluate transactions by how they rank percent-wise among all others.

The accounting team wants to analyze transactions by their rank as a percentage of all transactions. Write a query to calculate the percent rank of each transaction amount.
Write Your Query