Above-Average Salary | Dataford Interview Questions

Employees whose salary is above the average.

Asked in the technical stage as a live SQL round using an Employees/Departments schema. The candidate was expected to screen share, run the query, and paste the output in chat.

Output

Return employee_id, employee_name, department, and salary.
Include only employees whose non-null salary is greater than the overall average salary.
Sort by salary descending, then employee_id ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(100)	Employee's department name
salary	DECIMAL(10,2)	Annual employee salary

Your question is Above-Average Salary. 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