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

Department Average Salary and Headcount | Algorithm

MediumjoinsSQL

Department Average Salary and Headcount

The HR analytics team is preparing a report on department staffing and pay. They want to see the average salary and total number of employees for each department, so they can identify which departments might need budget adjustments or additional hires.

Return

departments.name : the department name avg_salary : the average salary of employees in the department headcount : the number of employees in the department Only include departments that have at least 3 employees. Order the results by avg_salary in descending order.

Expected output

name	avg_salary	headcount
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.