Get all possible airports
The task of the next two exercises is to search for all possible flight routes. This means that, first, you have to find out all possible departure and destination airports from the table flightPlan.
In this exercise, you will create a CTE table named possible_Airports using the UNION syntax which will consist of all possible airports. One query of the UNION element selects the Departure airports and the second query selects the Arrival airports.
Questo esercizio fa parte del corso
Hierarchical and Recursive Queries in SQL Server
Istruzioni dell'esercizio
- Define the CTE table
possible_Airportswith the fieldAirports. - Select the airports by combining
DepartureandArrivalairports. - Combine the departure with the destination airports using the correct statement.
- Select all possible
Airportsfrompossible_Airports.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Definition of the CTE table
___ possible_Airports (___) ___(
-- Select the departure airports
SELECT ___
FROM flightPlan
-- Combine the two queries
___
-- Select the destination airports
SELECT ___
FROM flightPlan)
-- Get the airports from the CTE table
SELECT ___
FROM ___;