Max Salary Department Query | Dataford Interview Questions

Wipro's workforce planning team needs to identify the department or departments containing the highest-paid employees. Write a PostgreSQL query that returns every department tied for the highest maximum employee salary.

Requirements

Join departments with employees, preserving departments even when they have no employees.
Calculate the maximum non-NULL salary for each department.
Return all departments tied for the overall highest departmental maximum salary.
Sort the result by department name.

Schema

departments

Column	Type	Description
department_idPK	INTEGER	Unique department identifier
department_name	VARCHAR(80)	Department name

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
department_id	INTEGER	Department assigned to the employee
salary	NUMERIC(12,2)	Annual employee salary

Your question is Max Salary Department Query. 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