JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Average Salary by Department for Departments with Multipl...

MediumjoinsSQL

Average Salary by Department for Departments with Multiple Employees

The HR analytics team wants to understand salary trends across different departments, but only for departments that have more than one employee. This will help them identify which teams might have internal pay disparities or consistencies.

Return

departments.name — department name COUNT(employees.id) — number of employees in the department AVG(employees.salary) — average salary in the department Only include departments with more than one employee. Order the results by AVG(employees.salary) in descending order.

Expected output

name	COUNT(e.id)	AVG(e.salary)
3 rows — values hidden, that's the puzzle

Your query should return 3 rows with these columns. Your column aliases don't need to match.

Ctrl+Enter to run

Run your query to see results here.