Rank Employees Within Departments | Dataford Interview Questions

Revature wants a salary ranking for active employees across its internal departments. Write a PostgreSQL query that returns each qualifying employee with their department, salary, and salary rank within that department.

Requirements

Join employees to departments and include only employees assigned to a valid department.
Include only employees whose employment_status is Active and whose salary is not NULL.
Use RANK() so employees with equal salaries receive the same rank, and order the results by department name, salary descending, and employee ID.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department_id	INT	References departments.department_id
salary	NUMERIC(10,2)	Annual employee salary
employment_status	VARCHAR(20)	Employee status such as Active or Inactive

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department display name

Your question is Rank Employees Within Departments. Start with the requirements and the two tables 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