New posts in Self Join

First observation by group using self-join

What is SELF JOIN and when would you use it?

Explanation of self-joins

Simplest way to do a recursive self-join?