Which scenario would most benefit from a self-join query?

A self-join is useful when a table needs to be matched against itself, often because two related roles are stored in the same table. Employees and their supervisors are commonly both rows in an employee table, so joining that table to itself can connect each employee with the row for their supervisor.

AI-written and checked against the verified answer.