SQL Self Join

What is a self join typically used for?

SELECT e1.name, e2.name as manager
FROM employees e1
JOIN employees e2 ON e1.manager_id = e2.id;
A

Optimizing query performance

B

Comparing rows within the same table

C

Joining to an identical backup table

D

Creating Cartesian products