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

Average Salary by Department (With Minimum Employee Count...

MediumjoinsSQL

Average Salary by Department (With Minimum Employee Count)

The HR team wants to review average salaries across departments but only for departments with at least 3 employees. They need this information to identify which departments meet a minimum staffing threshold and how their compensation compares.

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 3 or more employees. Order the results by average salary descending.

Expected output

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

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

Ctrl+Enter to run

Run your query to see results here.