Integrate Workforce Data with HR System | Dataford Interview Questions

A company is integrating a new workforce planning platform with its existing HR system. Write a SQL query to ensure data accuracy by identifying discrepancies in employee records between the two systems.

Requirements

Join the employees table from the HR system with the workforce_planning table using employee_id.
Identify employees that exist in the HR system but are missing from the workforce planning platform.
Include a flag to indicate if the employee is active in the HR system.
Return only those employees with discrepancies in their records.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique identifier for each employee
name	VARCHAR(255)	Employee's name
active	BOOLEAN	Indicates if the employee is currently active
department	VARCHAR(255)	Department where the employee works

workforce_planning

Column	Type	Description
employee_idPK	INT	Unique identifier for each employee in workforce planning
name	VARCHAR(255)	Employee's name as recorded in workforce planning
position	VARCHAR(255)	Position of the employee in workforce planning

Your question is Integrate Workforce Data with HR System. 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