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

Average Salary by Department with Minimum Headcount

MediumjoinsSQL

Average Salary by Department with Minimum Headcount

The HR analytics team wants to identify departments with enough staff to analyze compensation trends. They are interested in departments that have at least 3 employees and want to see the average salary for each of these qualifying departments.

Return

name (department name) avg_salary (average salary of employees in the department) Only include departments with at least 3 employees. Order the results by avg_salary in descending order.

Expected output

name	avg_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.