Applying sequential numerical values and rankings to rows.
Accessing adjacent row variables without self-joins.
Calculating cumulative metric flows across dataset splits.