Get the anchor & recursive member
The flight plan and the corresponding planning of flights from the departure airport to the destination airport is a common task for airline websites and traveling websites such as expedia.com. When planning such trips, it is common to have layovers. This helps make certain flight routes possible and reduces flight costs.
To strengthen your understanding of finding the anchor fields in a recursive CTE, you have to choose the best combination of fields from a typical flight table.
The first element should be the anchor element of the anchor member and the second element should be the connection field of the recursive member (e.g.: for an organization hierarchy the anchor element is the supervisor ID and the connection field is the employee ID).
Please find the correct combination of fields to create a flying route.
This exercise is part of the course
Hierarchical and Recursive Queries in SQL Server
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
