[Solved] Need Run Following Way Bottom Sql Queries Oracle Per Database Created Ton Applicable Infor Q37294153
I need to run the following (way down at the bottom) SQL Queries(Oracle) per the database created (a TON of applicable informationbelow is shown first). A comment must be included before each queryto indicate the query number. Need to maintain the specific orderof the queries. (Underneath all of the forthcoming applicableinformation are the SQL Queries to be run – way down at the bottom)This project is based on eight tables (AIRPORT, FLIGHT, DEPARTURES,PASSENGER, RESERVATION, EQUIP_TYPE, PILOTS, and TICKET) thatcontain data about the Belle Airlines. Background info about BelleAirlines: Belle Airlines is a regional carrier that operatesprimarily in the southwestern United States. At the present time,Belle Airlines operates its own reservation information system. Tosimplify our analysis, we will assume that all reservations onBelle Airlines flights are placed through Belle Airlines employees.Flights are not booked through travel agents and Belle Airlinesdoes not participate in industry-wide reservations services. Eachflight is assigned a unique flight number and has its own set offlight characteristics (ie. flight number, origin, destination,departure time, arrival time, meal code, base fare, mileage betweenorigin and destination, and number of changes in time zone betweenthe origin and destination of the flight). Departures of eachflight are stored in the Departures table. Each departure containsfour attributes (flight number, departure date, pilot id, andequipment number). Belle Airlines flies out of airports located allover the country. Data on these airports is stored in the Airporttable. Data on these airports includes: a three-character airportcode, location of the airport, elevation, phone number, streetaddress, city, stat, zip code, flight pay, date of birth, and datehired. The company also owns its own fleet of airplanes. Data onthese airplanes is stored in the Equip_Type table which containsthe following attributes: equipment number, equipment type, seatingcapacity, fuel capacity, and miles per gallon. Three additionaltables populate the Belle Airlines database: the Passenger table(with attributes: passenger name, itinerary number, andconfirmation number), the Reservation table (with attributes:confirmation number, reservation date, reservation name,reservation phone, reservation flight number, and reservationflight date), and the Ticket table (with attributes: itinerarynumber, flight number, flight date, and seat assignment).Applicable table data for Belle Airlines Database:
SQL Queries (10) to be run:
21. Display the number of departures that involve flights foreach of the three time zone differences.
22. Display the number of airports located in each state.
23. Display the number of departures where the distance flown isgreater than or equal to 1000 miles.
24. Display the difference in age between the oldest andyoungest pilot.
25. For each type of aircraft, display the total distance thatcan be flown before refueling. Display your results in descendingorder by total distance that can be flown.
26. For each passenger listed in the PASSENGER table, displaythe name of the person responsible for his or her reservation.
27. For each passenger listed in the PASSENGER table, displaythe name of the person responsible for his or her reservation onlyif the passenger himself or herself was not responsible for makingthe reservation.
28. For each reservation in the RESERVATION table, display thename of the pilot who will be piloting the flight.
29. Display those tickets that include only one flight.
30. Display the name of the passengers whose tickets includeonly one flight.
Expert Answer
Answer to I need to run the following (way down at the bottom) SQL Queries (Oracle) per the database created (a TON of applicable … . . .
OR
