Department Salary Analysis — Solution & ExplanationProblems / Department Salary Analysis / EditorialApproachThis is a straightforward aggregation problem.

Group the rows by department.

Aggregate using COUNT(*) for headcount, AVG(salary) for average (rounded to 2 decimals), and MAX(salary) for the highest salary.

Order the results alphabetically by department.

Complexity

A single pass over the data with a GROUP BY — O(n) where n is the number of rows.

Hints

Use GROUP BY to aggregate per department.

Remember to ROUND the average salary to 2 decimal places.

Solve Department Salary Analysis yourself →