Self Join Employees Table for Salaries

Question

Find all employees along with their manager's salary.

Accepted Answer

```sql
SELECT 
    e.name AS employee_name, 
    m.salary AS manager_salary
FROM employees e
JOIN employees m ON e.manager_id = m.id;
```

This query performs a self-join on the "employees" table to associate each employee with their respective manager and retrieves the manager's salary.