Employees and their managers
mediumEmployees and their managers
Workday SQL Interview Question
Workday's HR team is building an org chart and needs to know who reports to whom.
List every employee's name and their manager's name as manager_name. Employees without a manager must still appear, with NULL as their manager_name.
Asked of
- Data Analyst
- Business Analyst
- Analytics Engineer
- Data Engineer
employeesTable16 rows
| Column Name | Type |
|---|---|
| employee_id | BIGINT |
| name | VARCHAR |
| department | VARCHAR |
| salary | BIGINT |
| manager_id | BIGINT |
| hire_date | DATE |
employeesExample Input
| employee_id | name | department | salary | manager_id | hire_date |
|---|---|---|---|---|---|
| 1 | Ravi Kumar | Executive | 240000 | NULL | 2018-01-15 |
| 2 | Mei Lin | Engineering | 185000 | 1 | 2018-06-04 |
| 3 | Sofia Rossi | Engineering | 142000 | 2 | 2019-02-18 |
| 4 | James Park | Engineering | 128000 | 2 | 2019-09-02 |
| 7 | Diego Alvarez | Analytics | 168000 | 1 | 2018-10-22 |
| 8 | Hannah Weber | Analytics | 134000 | 7 | 2020-01-13 |
Example Output
| name | manager_name |
|---|---|
| Diego Alvarez | Ravi Kumar |
| Hannah Weber | Diego Alvarez |
| James Park | Mei Lin |
| Mei Lin | Ravi Kumar |
| Ravi Kumar | NULL |
| Sofia Rossi | Mei Lin |
Explanation
Sofia Rossi and James Park both report to Mei Lin, who reports to Ravi Kumar. Ravi Kumar is at the top of the company and has no manager, but still appears, with an empty manager name.
The example above is a small slice of the data. Your query runs against the full tables.
Company
Workday
Difficulty
medium
Topic
joins
Your query
Starting the SQL engine...