Recursive CTEs for Hierarchical Data

Multiple Table Joins

LEFT/RIGHT/FULL OUTER JOIN

Show employees with their managers

Find employees earning more than their manager

Build organizational hierarchy

What is a self join?

How to show employee-manager relationships?

When to use LEFT JOIN vs INNER JOIN for self joins?