a SQL query for the give CSV that have their own table List all airlines. For every airline, compute the number of regional airports (full name of airport contains the string 'Regional') from which that airline does NOT fly, considering source airport only. Sort by airport count in descending order. -------------------------------------------------------------- airlines.csv Id : unique identifier of the airline Name : full name of the airline Abbr : abbreviated name of the airline Country : country of the airline ----------------------------------------------------------------- airports.csv City : location of the airport Code : unique three-letter airport code Name : name of the airport Country : country of the airport
Using a SQL query for the give CSV that have their own table
List all airlines. For every airline, compute the number of regional airports (full name of airport contains the string 'Regional') from which that airline does NOT fly, considering source airport only. Sort by airport count in descending order.
--------------------------------------------------------------
airlines.csv
Id : unique identifier of the airline
Name : full name of the airline
Abbr : abbreviated name of the airline
Country : country of the airline
-----------------------------------------------------------------
airports.csv
City : location of the airport
Code : unique three-letter airport code
Name : name of the airport
Country : country of the airport
CAbbr : abbreviation of the country
------------------------------------------------------------------------
flights.csv
Airline : airline that manages the flight
FlightNo : flight number (unique for each airline, may repeat
for different airlines)
Source : Code for the airport from which the flight originates
Destination : Code for the airport at which the flight terminates
Step by step
Solved in 2 steps
