Employee vs Manager Salary Query | Dataford Interview Questions

Business Context

Chewy’s people analytics team wants to identify compensation anomalies for review. An employee qualifies when their salary is strictly greater than the salary of their directly assigned manager.

Task

Write a PostgreSQL query using a self-join on employees to return every employee whose salary exceeds their manager’s salary.

Requirements

Return the employee’s name and salary, along with the manager’s name and salary.
Exclude employees without an assigned manager and employees whose salary is equal to or less than their manager’s salary.
Order results by employee salary descending, then employee ID ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee’s full name
salary	NUMERIC(10,2)	Annual employee salary
manager_id	INT	References employees.employee_id for the direct manager
department	VARCHAR(50)	Organizational department

Your question is Employee vs Manager Salary Query. 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