Hierarchical Self Join for Org Chart

Write a query using a self join to show each employee alongside their manager's name. Include employees who have no manager (show NULL). Return employee_name, manager_name, ordered by employee_name.

Expected Output: Each employee with their manager's name.