Before comp reviews, Amazon's HR team might pull the top salary per department to see whether pay ceilings make sense across orgs. 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 |