Transaction Trail Analysis

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.
Write Your Query