SQL Practice Questions Only | Dataford Interview Questions

Leetcode SQL medium questions mainly.

Write a PostgreSQL query that returns every employee whose salary is the highest within their department. Include all employees tied for the highest salary. Employees without a department and departments without qualifying employees must not appear.

Output

One row per qualifying employee with department_name, employee_name, and salary
Sort by department_name ascending, then employee_name ascending

Schema

departments

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

employees

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

Your question is SQL Practice Questions Only. 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