SQL Query by Employee ID | Dataford Interview Questions

Write a SQL query to get employee details based on Employee ID (CEO to normal employee).

Given an employee ID, return that employee's details and the corresponding reporting chain through the CEO. Preserve the employee row even when an optional department or hierarchy relationship is missing.

Output

One row for the requested employee
Include employee ID, name, title, department, manager, director, vice president, and CEO details
Return hierarchy names and IDs from the direct manager up to the CEO

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
full_name	VARCHAR(120)	Employee's full name
job_title	VARCHAR(100)	Employee's job title
manager_id	INT	Employee ID of the direct manager
department_id	INT	Associated department identifier

departments

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

Your question is SQL Query by Employee ID. 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