Lowest and Highest Salary in Department

For each employee return the name, salary and the lowest and highest salary of their department (columns lowest and highest). Order by name.

Table schema

Employees(id INT PRIMARY KEY, name VARCHAR(50), department_id INT, salary INT)

Sample data

id | name | department_id | salary
1 | A | 1 | 100
2 | B | 1 | 200
3 | C | 1 | 300