Questions like "employees who earn more than their manager" or "employees with no manager" are interview favourites. They all rest on a self join, where each employee row is matched with their manager's row through manager_id. Use this pattern any time a table refers to itself. Choose a LEFT JOIN when people without a manager, like the CEO, must still appear.