Top Three Departments Query | Dataford Interview Questions

Write a query to find the top three highest-paying departments using a window function.

Use average employee salary to define highest-paying. Include departments whose rank is among the top three, allowing ties to share a rank.

Output

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	Employee department identifier
salary	INT	Annual employee salary

Your question is Top Three Departments 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.

Write a query to find the top three highest-paying departments using a window function.

Use average employee salary to define highest-paying. Include departments whose rank is among the top three, allowing ties to share a rank.

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	Employee department identifier
salary	INT	Annual employee salary

Your question is Top Three Departments 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.