Scenario SQL Question

Employees in the Highest Paying Department

Build mastery in Subqueries with this scenario-based SQL challenge and live execution support.

Problem Statement

Find every employee whose department has the highest average salary. Return employee_id, first_name, last_name, department_name, salary — ordered by salary DESC, employee_id.

Relevant Tables

employeesdepartments

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Subquery Types & ClassificationSubqueries & CTEs
Correlated SubqueriesSubqueries & CTEs
Common Table ExpressionsSubqueries & CTEs