Self-Join Logic for Pairwise Analysis

Compare entities against their own history or neighbors within the same table.