Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
The very basics
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive CTEs


Excellent. Another modification is waiting for you.


Show the id, first and last name, and the superior_id of each subordinate of the employee with id = 2. (Show not only the direct subordinates, but also their subordinates, etc.) Don't forget to show the employee!

Get rid of any unused columns, too.

Stuck? Here's a hint!

The anchor member is now the person with id = 2.