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: