SQL Salary Threshold Query | Dataford Interview Questions

Your question is SQL Salary Threshold Query. Start with the requirements and the two tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Fortitude Systems uses the Workforce Hub to review employee compensation. Write a PostgreSQL query that identifies employees whose salary is equal to or greater than 10,000.

Requirements

Return the employee ID, first name, last name, salary, and department name.
Include employees even when their department is missing or does not match a department record. Display Unassigned for those employees.
Return results in descending salary order, using first name ascending to break salary ties.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
first_name	VARCHAR(50)	Employee first name
last_name	VARCHAR(50)	Employee last name
department_id	INTEGER	References departments.department_id
salary	NUMERIC(10,2)	Annual employee salary

departments

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