Answered step by step
Verified Expert Solution
Question
1 Approved Answer
List all airports from which airline Southwest operates more flights than Northwest. Include only airports that have at least one outgoing flight on Southwest and
List all airports from which airline Southwest operates more flights than Northwest. Include only airports that have at least one outgoing flight on Southwest and at least one on Northwest. List airport code along with counts for each airline as two separate columns. Order by source airport code.
EXPECTED :
| ADT | 2 | 1 |
| AKI | 2 | 1 |
| ANQ | 3 | 1 |
| ANV | 2 | 1 |
| ANY | 3 | 1 |
| ARB | 3 | 2 |
| ATS | 2 | 1 |
| AYZ | 4 | 1 |
| CVO | 2 | 1 |
| JLH | 2 | 1 |
| WKK | 3 | 2 |
TABLES:
AIRLINES:
| Id | Name | Abbr | Country |
| 1 | United Airlines | UAL | USA |
| 2 | US Airways | USAir | USA |
| 3 | Delta Airlines | Delta | USA |
| 4 | Southwest Airlines | Southwest | USA |
| 5 | American Airlines | American | USA |
| 6 | Northwest Airlines | Northwest | USA |
| 7 | Continental Airlines | Continental | USA |
| 8 | JetBlue Airways | JetBlue | USA |
| 9 | Frontier Airlines | Frontier | USA |
| 10 | AirTran Airways | AirTran | USA |
| 11 | Allegiant Air | Allegiant | USA |
| 12 | Virgin America | Virgin | USA |
AIRPORTS:
| City | Code | Name | Country | CAbbr |
| Apalachicola | AAF | Municipal | United States | US |
| Abilene | ABI | Municipal | United States | US |
| Ambler | ABL | Ambler | United States | US |
| Albuquerque | ABQ | Albuquerque International | United States | US |
| Aberdeen | ABR | Municipal | United States | US |
| Albany | ABY | Dougherty County | United States | US |
| Arcata | ACV | Arcata | United States | US |
| Adrian | ADG | Lenawee County | United States | US |
| Adak Island | ADK | Adak Island Ns | United States | US |
| Ardmore | ADM | Ardmore Municipal Arpt | United States | US |
| Andrews | ADR | Andrews | United States | US |
| Ada | ADT | Ada | United States | US |
| Aleneva | AED | Aleneva | United States | US |
| Albert Lea | AEL | Albert Lea | United States | US |
| Allakaket | AET | Allakaket | United States | US |
| Alexandria LA | AEX | Alexandria International | United States | US |
| Afton | AFO | Municipal | United States | US |
| Angoon | AGN | Angoon | United States | US |
| Ardmore | AHD | Downtown | United States | US |
| Arapahoe | AHF | Municipal | United States | US |
| Amery | AHH | Municipal | United States | US |
| Athens | AHN | Athens | United States | US |
| Amchitka | AHT | Amchitka | United States | US |
| Alliance | AIA | Alliance | United States | US |
| Anita Bay | AIB | Anita Bay | United States | US |
| Anderson | AID | Municipal | United States | US |
| Aiken | AIK | Municipal | United States | US |
| Aliceville AL | AIV | George Downer | United States | US |
| Akron/Canton | AKC | Fulton International | United States | US |
| Akiak | AKI | Akiak | United States | US |
| Akhiok | AKK | Akhiok SPB | United States | US |
| Akron CO | AKO | Colorado Plains Regional Airport | United States | US |
| Anaktuvuk | AKP | Anaktuvuk | United States | US |
| Albany | ALB | Albany International | United States | US |
| Alpine | ALE | Alpine | United States | US |
| Alice | ALI | International | United States | US |
| Alamogordo | ALM | Municipal | United States | US |
| Alton | ALN | Alton | United States | US |
| Alamosa | ALS | Municipal | United States | US |
| Alexander City AL | ALX | Thomas C Russell Fld | United States | US |
| Alitak | ALZ | Alitak SPB | United States | US |
| Amarillo | AMA | Rick Husband Amarillo International | United States | US |
| Alma | AMN | Gratiot Community | United States | US |
| Ames | AMW | Ames | United States | US |
| Anaheim | ANA | Orange County Steel Salvage Heliport | United States | US |
| Anniston AL | ANB | Anniston Metropolitan | United States | US |
| Anchorage | ANC | Ted Stevens Anchorage International Airport | United States | US |
| Anderson | AND | Anderson | United States | US |
| Aniak | ANI | Aniak | United States | US |
| Annette Island | ANN | Annette Island | United States | US |
| Annapolis | ANP | Lee | United States | US |
| Angola | ANQ | Tri-State Steuben Cty | United States | US |
| Anvik | ANV | Anvik | United States | US |
| Ainsworth | ANW | Ainsworth | United States | US |
| Anthony | ANY | Anthony | United States | US |
| Amook | AOS | Amook | United States | US |
| Aberdeen | APG | Phillips AAF | United States | US |
| Alpena | APN | Alpena County Regional | United States | US |
| Apple Valley | APV | Apple Valley | United States | US |
| Alyeska | AQY | Alyeska | United States | US |
| Ann Arbor MI | ARB | Municipal | United States | US |
| Arctic Village | ARC | Arctic Village | United States | US |
| Neptune | ARX | Asbury Park | United States | US |
| Aspen | ASE | Aspen | United States | US |
| Astoria | AST | Astoria | United States | US |
| Ashland | ASX | Ashland | United States | US |
| Ashley | ASY | Ashley | United States | US |
| Antlers | ATE | Antlers | United States | US |
| Athens | ATO | Ohio University | United States | US |
| Artesia | ATS | Artesia | United States | US |
| Appleton | ATW | Outagamie County | United States | US |
| Alakanuk | AUK | Alakanuk | United States | US |
| Alexandria Bay | AXB | Alexandria Bay | United States | US |
| Algona | AXG | Algona | United States | US |
| Alexandria | AXN | Alexandria | United States | US |
| Altus | AXS | Municipal | United States | US |
| Angel Fire | AXX | Angel Fire | United States | US |
| Amityville | AYZ | Zahns | United States | US |
| Akron/Canton OH | CAK | Akron/canton Regional | United States | US |
| Albany | CVO | Albany | United States | US |
| Abilene | DYS | Dyess AFB | United States | US |
| Anchorage | EDF | Elmendorf Afb | United States | US |
| Alexandria | ESF | Esler Field | United States | US |
| Alamogordo | HMN | Holloman AFB | United States | US |
| Arlington Heights | JLH | US Army Heliport | United States | US |
| Akiachak | KKI | Spb | United States | US |
| Akutan | KQA | Akutan | United States | US |
| Altus | LTS | Altus AFB | United States | US |
| Athens | MMI | McMinn County | United States | US |
| Anchorage | MRI | Merrill Field | United States | US |
| Albany | NAB | Albany NAS | United States | US |
| Anacostia | NDV | USN Heliport | United States | US |
| Alameda | NGZ | NAS | United States | US |
| Anacortes | OTS | Anacortes | United States | US |
| Anniston | QAW | Ft Mcclellan Bus Trml | United States | US |
| Anguilla | RFK | Rollang Field | United States | US |
| Anniston | RLI | Reilly AHP | United States | US |
| Amarillo | TDW | Tradewind | United States | US |
| Abingdon | VJI | Virginia Highlands | United States | US |
| Aleknagik | WKK | Aleknagik | United States | US |
Flights: (To much Data to add)
| Airline | int | NO | PRI | 0 | |
| FlightNo | int | NO | PRI | 0 | |
| Source | char(3) | YES | MUL | null | |
| Destination | char(3) | YES | MUL | null |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started