Who is your manager?

In this exercise, we are going to use the dataset of an IT-organization which is provided in the table employee. The table has the fields ID (ID of the employee), Name (the employee's name), and Supervisor (the ID of the supervisor).

The IT-organization consists of different roles and levels.

A section of the entire hierarchy

For example, this organization has one IT director (ID=0, Heinz Griesser) with many subordinate employees (all on the management level). Under the IT director you can find the IT architecture manager (ID=10, Andreas Sternig) with three subordinate employees.

First, we want to answer the question: Who are the supervisors for each employee?

We are going to solve this problem by recursively querying the dataset.

Create a CTE with the name employee_hierarchy.
Select the information of the IT director as the initial step of the CTE by filtering on his ID.
Perform a join with employee to get the name of the manager.

Take Hint (-30 XP)

Exercise

Who is your manager?

Instructions