gitGood.dev
← SQL Playground

Average Salary by Department

MediumPremium
For each department, return its name and the average employee salary as avg_salary, but only for departments whose average salary is above 90000. Order by avg_salary descending.
Schema
departments (id, name)
employees (id, name, department_id, salary, hire_date)
Loading editor…
Hints