Finance is benchmarking compensation and wants to flag departments that pay above a certain threshold. Using the employees table, find every department where the average salary exceeds 100,000.
Return department and avg_salary (as an integer), ordered alphabetically by department.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | INTEGER |
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 110000 |
| 2 | Bob | Engineering | 130000 |
| 3 | Carol | Marketing | 70000 |
| 4 | Dave | Marketing | 90000 |
| 5 | Eve | HR | 90000 |
| 6 | Frank | HR | 110000 |
| department | avg_salary |
|---|---|
| Engineering | 120000 |