Self-Join: Employees and Managers

The Employee table has a self-referencing ReportsTo column. Use a self-join to show each employee alongside their manager's name.

Write a query that joins the Employee table to itself to show employee-manager relationships.

Schema: Employee

Requirements:

• Self-join Employee table using ReportsTo
• Return Employee name and Manager name
• Format names as 'FirstName LastName'
• Include all employees (even without managers)

Self-Join Pattern:

SELECT a.column, b.column
FROM table a
LEFT JOIN table b ON a.foreign_key = b.primary_key;