SQL Min and Max Without Subqueries | Dataford Interview Questions

GEP's people analytics team needs a quick salary-extremes report for its workforce data. Write a PostgreSQL query to identify every employee whose non-null salary is either the highest or lowest in the employees table, without using subqueries or CTEs.

Requirements

Return the employee ID, employee name, salary, and a salary_type label.
Label rows as Highest or Lowest.
Return all employees tied at either salary extreme.
Exclude employees whose salary is NULL, and order the result from highest salary to lowest salary.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	GEP department
salary	NUMERIC(12,2)	Annual employee salary

Your question is SQL Min and Max Without Subqueries. 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

Requirements

Return the employee ID, employee name, salary, and a salary_type label.
Label rows as Highest or Lowest.
Return all employees tied at either salary extreme.
Exclude employees whose salary is NULL, and order the result from highest salary to lowest salary.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	GEP department
salary	NUMERIC(12,2)	Annual employee salary

Your question is SQL Min and Max Without Subqueries. 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.