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.