Group by Department
We're still working at devils.fyi, a website similar to levels.fyi.
Students have started show interest in the site!
They use our data to help pick their areas of study.
However, they care more about salary information for departments than specific companies.
Luckily, we have department in our employees table too.
employees
| column_name | type |
|---|---|
id | INTEGER |
name | VARCHAR |
company | VARCHAR |
department | VARCHAR |
job_title | VARCHAR |
salary | INTEGER |
start_date | DATE |
Select each department, and its average salary (name that column avg_salary).
