Session Ready
Exercise

All flight routes from Vienna

Previously, you looked at how the flight data is structured. You have already identified the necessary fields from the flightPlan table. These will be used in this exercise for the anchor and the recursive query.

The task of this exercise is to combine this knowledge to create a recursive query that:

  • gets all possible flights from Vienna
  • has a travel cost under 500 Euro
  • has fewer than 5 stops

You should output only the destinations and the corresponding costs!

Instructions 1/3
undefined XP
  • 1
  • 2
  • 3
  • Initialize the number of stops, increment it in the recursive query, and limit it to less than 5.