HR is doing a compensation review and wants to know the ceiling in each department. Using the employees table, find the highest salary in each department.
Return department and max_salary, sorted alphabetically.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | INTEGER |
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 120000 |
| 2 | Bob | Marketing | 85000 |
| 3 | Carol | Engineering | 135000 |
| 4 | Dave | HR | 72000 |
| 5 | Eve | Marketing | 90000 |
| department | max_salary |
|---|---|
| Engineering | 135000 |
| HR | 72000 |
| Marketing | 90000 |