Employees Earning More Than Managers | Dataford Interview Questions

SQL: find employees earning more than their manager.

Asked in the Round 1 stage covering DSA, SQL, and CS fundamentals. The data is stored in an employees table where each employee may reference another employee as their manager.

Output

Return one row per employee whose salary is strictly greater than their manager's salary.
Include employee_name, employee_salary, manager_name, and manager_salary.
Exclude employees without a manager or with a NULL salary, and order by employee_name ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
salary	NUMERIC(10,2)	Employee's salary
manager_id	INT	Employee identifier of the employee's manager

Your question is Employees Earning More Than Managers. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem