Getting everything ready for you…

Loading courses, problems and your progress. This takes just a moment.

0s

SQL practice › Joins & grouping

Average Salary by Department

Medium · Joins & grouping

Return each department name with the average salary of its employees, rounded to 2 decimal places. Only departments that have employees.

Hint

ROUND(AVG(x), 2).

Write your query on this page — it runs against the sample company database in your browser and is checked instantly.

Next problem: Departments With No Employees