Budget season is coming up, and LinkedIn's people analytics team needs a compensation benchmark to bring into planning. Using the employees table, return the average salary across all employees as avg_salary.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | INTEGER |
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 90000 |
| 2 | Bob | Marketing | 70000 |
| 3 | Carol | HR | 60000 |
| 4 | Dave | Engineering | 110000 |
| avg_salary |
|---|
| 82500 |
(90000 + 70000 + 60000 + 110000) / 4 = 82500.