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

Average Salary by Manager for Each Department | Algorithm

MediumaggregationSQL

Average Salary by Manager for Each Department

Department heads want to recognize managers who oversee larger teams and understand compensation patterns within their departments. For each department, identify every manager who directly supervises at least two employees in that department, and provide the department name, manager name, the count of their direct reports in that department, and the average salary of those reports. List the results ordered by department name and then by manager name.

Return

department_name : the name of the department manager_name : the name of the manager num_reports : number of employees directly reporting to the manager in that department avg_report_salary : average salary of those direct reports Include only managers with at least two direct reports in the same department. Sort by department_name, then manager_name .

Expected output

department_name	manager_name	num_reports	avg_report_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.