SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Find Employees Who Earn More Than Their Manager

Build mastery in Ranking Nth Value with this scenario-based SQL challenge and live execution support.

Problem Statement

Find every employee who out-earns their direct manager. Show employee first_name, employee last_name, employee_salary, manager first_name, manager last_name, manager_salary — ordered by employee_salary DESC, employee first_name.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: