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.

Cet exercice fait partie du cours

Hierarchical and Recursive Queries in SQL Server

Afficher le cours

Instructions

Define the CTE table possible_Airports with the field Airports.
Select the airports by combining Departure and Arrival airports.
Combine the departure with the destination airports using the correct statement.
Select all possible Airports from possible_Airports.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- 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 ___;

Modifier et exécuter le code