Objective

Write a SQL query to find employees who earn more than their direct managers.

Table Schema:

• employees

Task Requirements:

• Compare each employee's salary with their manager's salary
• Find employees whose salary is greater than their manager's salary
• Output employee ID and name
• Sort results by employee ID in ascending order
  
  

Output columns: employee_id, employee_name

SELECT 
    e.employee_id,
    e.employee_name
FROM employees e
JOIN employees m ON e.manager_id = m.employee_id
WHERE e.salary > m.salary
ORDER BY e.employee_id ASC;

Explanation

Step 1: Self-Join to Connect Employees with Managers

Alias the employees table twice - e for employees and m for managers - and join on e.manager_id = m.employee_id to pair each employee with their direct manager.

FROM employees e
JOIN employees m ON e.manager_id = m.employee_id

Step 2: Filter Employees Earning More Than Their Manager

Apply WHERE e.salary > m.salary to keep only employees whose salary exceeds their manager's salary.

WHERE e.salary > m.salary

Step 3: Sort Results

Order by employee_id ascending.

ORDER BY e.employee_id ASC