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

Department Headcount Including Subordinates | Algorithm

Mediumrecursive-cteSQL

Department Headcount Including Subordinates

The HR analytics team is preparing a report to identify managers with significant team sizes across departments for organizational planning. They want to know which managers in each department have at least three employees reporting to them, counting both direct and indirect reports.

Return

manager_name : the name of the manager department_name : the name of the manager's department total_reports : the total number of employees reporting (directly or indirectly) to the manager Include only managers who have at least three total reports. Order the results by department_name (A-Z), then manager_name (A-Z).

Expected output

manager_name	department_name	total_reports
1 row — values hidden, that's the puzzle

Your query should return 1 row with these columns. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.