Employee vs Manager Salary Query

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Employee vs Manager Salary Query. Start with the requirements and the one table on the right.

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

You need to log in / sign up to run or submit.

Problem

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

Tablesemployees

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results