Finance wants a list of employees who are paid above the company average. Using the employees table, find every employee whose salary is strictly above the company-wide average — return name, department, and salary, ordered by salary descending.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | INTEGER |
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 120000 |
| 2 | Bob | Marketing | 80000 |
| 3 | Carol | Engineering | 95000 |
| 4 | Dave | HR | 65000 |
| 5 | Eve | Engineering | 110000 |
Average = 94000. Employees above that: Alice (120000), Eve (110000).
| name | department | salary |
|---|---|---|
| Alice | Engineering | 120000 |
| Eve | Engineering | 110000 |