gitGood.dev
← SQL Playground

Departments With High Average Salary

Easy
Return the 'name' of each department whose average employee 'salary' is greater than 100000, along with that average as 'avg_salary'. Join 'departments' to 'employees'.
Schema
departments (id, name)
employees (id, name, department_id, salary, hire_date)
Loading editor…
Hints