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 is reviewing compensation patterns across departments to identify areas with sufficient staffing and competitive pay. They want to see the average salary for each department, but only for departments that have at least 3 employees assigned. Exclude any departments with fewer than 3 employees from the results.

Return

name : the department name avg_salary : the average salary of employees in that department Only include departments with at least 3 employees, and 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.

SQLite · Ctrl+Enter to run

Run your query to see results here.