Employees Earning More Than Managers | Dataford Interview Questions

Arcesium's workforce reporting team needs to identify employees whose compensation exceeds that of their direct manager. Write a PostgreSQL query using a self-join on the employees table.

Requirements

Return the employee's name and salary, along with the direct manager's name and salary.
Include only employees whose salary is strictly greater than their manager's salary.
Exclude employees without a manager, employees with equal salaries, and rows where either salary is NULL.
Order the results by employee name in ascending order.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
manager_id	INT	References the direct manager's employee_id
salary	NUMERIC(12,2)	Annual employee salary

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

Arcesium's workforce reporting team needs to identify employees whose compensation exceeds that of their direct manager. Write a PostgreSQL query using a self-join on the employees table.

Requirements

Return the employee's name and salary, along with the direct manager's name and salary.
Include only employees whose salary is strictly greater than their manager's salary.
Exclude employees without a manager, employees with equal salaries, and rows where either salary is NULL.
Order the results by employee name in ascending order.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
manager_id	INT	References the direct manager's employee_id
salary	NUMERIC(12,2)	Annual employee salary

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.