Self-joins in SQL

Let's talk about self-joins in SQL. It's one of the join types that don't have their own keyword, but is more of a concept. It essentially means you are joining a table with itself to retrieve some result from another row. Prior to the introduction o...