Home / Expert Answers / Computer Science / nbsp-give-the-database-diagram-above-write-the-following-sql-queries-list-all-flights-for-each-p-pa829

(Solved):   give the database diagram above write the following sql queries: List all flights for each p ...



 

give the database diagram above write the following sql queries:

List all flights for each passenger.   Show Passenger First Name and Last Name.  Show Flight Number and Date.  Sort by Passenger Last Name ascending.
List all flights for a passenger “Ware Hyjeked”.  Show Flight Number and Flight Date.  Sort by Flight Date, descending. 
List all passengers that have taken a flight with FlyMe2theMoon.  Show Passenger First Name and Last Name only.  Only show passenger once. 
Show only passengers in the database who have not taken a flight. Show Passenger First Name and Last Name.  
Show only planes that have not had any maintenance completed.  Show All Plane information. 
Show total number of flights for each pilot.  If the pilot has ZERO, show them too.   Show Pilot first name and last name and total flights. 
Show total number of hours of maintenance performed on each plane.  Show all plane information and hours. 
Show total flight miles for each passenger who have flown over 5000 miles in total. Show Passenger first name and last name and Total Miles.  Sort by Total Miles, descending. 
Show the passenger(s) that have flown the most miles.  Show Passenger first name and last name and Total Miles.
Show average flight miles for each Pilot during the April, 2022
Show all Boeing 767-300F that have been worked on by Maintenance Worker “Gressy Nuckles”. 
Show all Passengers that have taken a flight where Pilot “Ima Soring” and Attendant “Sherley Ujest” were on the same flight.  Show Passenger First Name and Last Name.  Show Flight  Number and Date.
Show Attendants and their total flights(only if more than 1) where they originated out of CVG airport during April, 2022.  Show Attendant First Name and Last Name and Total Flights.  Sort by Total Flights descending. 
Show all Passengers that have NOT taken a flight where Pilot “Ima Soring” and Attendant “Sherley Ujest” were on the same flight.   Show Passenger First Name and Last Name.  
Show total number of times Pilot “Tip Seenow” has flown  Boeing 747-B. 
Show all Passengers that live on a street with the work “Oak” in it.
 



We have an Answer from Expert

View Expert Answer

Expert Answer


ANSWER: 1. SELECT p.FIRST_NAME, p.LAST_NAME, f.FLIGHT_NUMBER, F.FLIGHT_DATE FROM {{ PASSENGERS p INNER JOIN
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe