Exercise

Get the hierarchy position

An important problem when dealing with recursion is tracking the level of recursion. In the IT organization, this means keeping track of the position in the hierarchy of each employee.

For this, you will use a LEVEL field which keeps track of the current recursion step. You have to introduce the field in the anchor member, and increment this value on each recursion step in the recursion member.

Instructions

100 XP

Initialize the field LEVEL to 1 at the start of the recursion.
Select the information of the IT director as the initial step of the CTE by filtering on his ID.
Set LEVEL to the current recursion step.
Perform a JOIN with the defined CTE on the IDs of the supervisor and the employee.

Take Hint (-30 XP)