Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Tables:

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

Wanted Output:

Northwest Airlines 2
Southwest Airlines 2
United Airlines 2
AirTran Airways 1
Allegiant Air 1
American Airlines 1
Delta Airlines 1
Frontier Airlines 1
JetBlue Airways 1
Virgin America 1
Continental Airlines 0
US Airways 0

PLEASE EXPLAIN

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And SQL

Authors: Lucy Scott

3rd Edition

1087899699, 978-1087899695

More Books

Students also viewed these Databases questions

Question

1. Does your voice project confidence? Authority?

Answered: 1 week ago