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

Top Earners Per Department | Algorithm

MediumwindowSQL

Top Earners Per Department

The HR analytics team wants to recognize top earners within each department for a company-wide report. They need a list showing every department alongside the employee(s) who earn the highest salary in that department. This will help highlight standout performers and salary leaders in each area.

Return

department_name : the name of the department employee_name : the name of the employee with the top salary in their department Include all employees tied for the highest salary within their department. Only include departments that have employees. Order the results by department_name, then by employee_name .

Expected output

department_name	employee_name
3 rows — values hidden, that's the puzzle

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

SQLite · Ctrl+Enter to run

Run your query to see results here.