Joins Scenario and Schemas | Dataford Interview Questions

Explain joins using a scenario and show how the table schemas affect the result.

Use the provided employees and departments tables to demonstrate the result of joining employees to their departments. Account for nullable department references and departments without employees.

Output

Return one row per employee with employee_id, employee_name, department_id, and department_name.
Include every employee, including employees without a department.
Sort by employee_id ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department_id	INT	Referenced department identifier; null when unassigned

departments

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

Your question is Joins Scenario and Schemas. 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