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