Introduction
The very basics
Infinite looping
Processing trees with recursive CTEs
19. Hierarchical company 2/3
Processing graphs with recursive ctes
Summary

Instruction

Good job. Let's go one step further.

Exercise

The result of the query you wrote in the previous exercise is already in the template. Your task is to show not only the boss, but also his immediate subordinates. For them, the Path column should contain N'Boss->' plus the LastName of each respective employee. Take the results from the template and UNION them with the boss's immediate subordinates.

Stuck? Here's a hint!

Use the concatenation operator + to create the whole path.