73. Transaction Trail Analysis
Rank transactions within each species and compare to the previous one.
The accounting team wants to analyze transaction patterns. Write a query to calculate the rank of each transaction amount within each species and determine the difference between the current and previous transaction amounts.
Explanation: