SELECT AirportName FROM Airports WHERE AirportCode NOT IN (SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights)
Which airports do not have departing or arriving flights?
SELECT AirportName FROM Airports WHERE AirportCode NOT IN ( SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights )
select airportname from airports where airportcode not in ( select sourceairport from flights union select destairport from flights )
Which airports do not have departing or arriving flights ?