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

Average Salary by Department for Departments with At Leas...

MediumaggregationSQL

Average Salary by Department for Departments with At Least 3 Employees

A compensation analyst is evaluating departments with a significant number of employees to benchmark salary levels. They need to identify all departments that have at least three employees and see how their average salaries compare.

Return

name (the name of the department) avg_salary (the average salary of employees in that department) Only include departments with three or more employees, and list the results by highest to lowest average salary.

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.