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

Average Salary per Department with Minimum Staff | Algorithm

MediumjoinsSQL

Average Salary per Department with Minimum Staff

The HR team is reviewing compensation across the company and wants to focus on departments with a substantial number of employees. They need to see the average salary for each department that has at least 3 employees, along with the department name and the total number of employees in each.

Return

name : the department's name avg_salary : the average salary of employees in the department employee_count : the total number 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	employee_count
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.