A Recursive query can loop through a result set and is able to parse data structures like a hierarchical data structure
In this example we will start with a table of employees and we want a query to return the employees based on their manager_id
In this example Cindy Smith is the Boss since she has no Manager