Understanding the Difference Between Rows of the Same Column: Self-Joins, Window Functions, and Aggregations