User

Categorize transactions into different types $($Payment$,$ Withdrawal, Deposit, Transfer$)$ based on the transaction description.

Extract the account number from the description for each transaction using the MID and FIND functions.

Extract the dollar amount from the description for each transaction using the RIGHT function.

Calculate the total amount for each type of transaction.

Identify transactions with amounts above the overall average.

Assign a rank to each transaction based on the transaction amount.