Question: SQL Database Queries Typed only please SQL ete Given the following schema: CITY (Name. Nation, Population) AIRPORT (Code, City_FK, Nation_FK, NumTracks) FLIGHT (ElightlD, DayOfWeek, DepartureAirport
SQL ete Given the following schema: CITY (Name. Nation, Population) AIRPORT (Code, City_FK, Nation_FK, NumTracks) FLIGHT (ElightlD, DayOfWeek, DepartureAirport FK, DepartureTime, ArrivalAirport_FK, ArrivalTime, Plane FK) PLANE (12. Type, NumPassenger, CargoSize) Where the following foreign keys are defined: City_FK, Nation EK in table AIRPORT- Name, Nation in table CITY DepartureAirportFK in table FLIGHT ? Code in table AIRPORT ArrivalAirport FK in table FLIGHT -Code in table AIRPORT Plane_FK in table FLIGHT -ID in table PLANE . Formulate SQL queries to find: Cities having at least one airport for which the number of track is not known, showing the 2. Types of the airplanes that are not used on any route, showing the airplane type and cargo size 3, Planes used on less more than 3 routes, showing the plane type and the number of routes in. 1. name, nation, and population of such cities which it is used Airports offering domestic routes, showing the city where the-airport is and the domestic destinations 4. Airports for which all arrivals are international (that is, no domestic flight arrival), showing the city where the airport is and all origin cities 5. Airports serving both domestic and international flights, showing the city where the airport is and all destination cities 6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
