Join Employees and Departments | Dataford Interview Questions

Join Employees with Departments and display name and department.

Asked in the technical stage. This was a live SQL round using a given Employees/Departments schema; the candidate shared their screen, ran the query, and pasted the output in chat.

Output

Return one row per employee with columns name and department.
Include employees without an assigned department, displaying Unassigned for the department.
Order by employee name ascending, then employee ID ascending for ties.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department_id	INT	Assigned department identifier

departments

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

Your question is Join Employees and Departments. 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