SQL Employee Manager Query | Dataford Interview Questions

Write a SQL query to return each employee name along with their manager name from a table with columns emp_id, emp_name, and manager_id where manager_id can be NULL.

Use the employees table. Include every employee, represent missing managers with NULL, and sort the results by emp_id.

Output

One row per employee
Columns: employee_name, manager_name
Include employees without a manager
Order by employee ID ascending

Schema

employees

Column	Type	Description
emp_idPK	INT	Unique employee identifier
emp_name	VARCHAR(100)	Employee full name
manager_id	INT	Identifier of the employee's manager

Your question is SQL Employee Manager Query. Start with the requirements and the one table 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