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

Average Salary by Department with Minimum Staff | Algorithm

MediumjoinsSQL

Average Salary by Department with Minimum Staff

The HR team is analyzing compensation trends across the company and wants to focus on departments with a substantial number of employees. They need to know the average salary for each department, but only for those departments that have at least 3 employees assigned to them.

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.

SQLite · Ctrl+Enter to run

Run your query to see results here.