employees(employee_id, employee_name, manager_id, salary)

Return the employee_id and employee_name of everyone earning strictly more than their direct manager.

The table references itself, so this needs a self-join. Employees with no manager have a NULL manager_id and cannot qualify.

Tables

employees

employee_id  employee_name  manager_id  salary
-----------  -------------  ----------  ---------
1            Ada            NULL        120000.00
2            Bo             1           130000.00
3            Cy             1           120000.00
4            Di             2           90000.00
5            Eli            2           140000.00

Expected result

employee_id  employee_name
-----------  -------------
2            Bo
5            Eli