Please help with these 15 SQL queries with reference to the tables given above-

Select flight number, origination and destination for all reservations booked by Ole Olson, Order results by flight number.

List all the passengers with reservation along with the name of the person that made the reservation

List pilot names for pilots who have no scheduled departures in April 2017.

List the equipment type and max distance possible on a full tank of fuel.

List flight number and number of passengers as "Number of Passengers" for flights that have more than 5 passengers.

Display flight number, departing/destination airport, Departure time as "Departure Time", Arrival time as "Arrival Time" for flights not departing on April 18, 2017.

Display departing airport code as "Departs From", Arriving airport code as "Arrives at", maximum fair as "Maximum Fair" for flights that have maximum fare for flights between these two airports.

Display passenger name, seat number as "Seat Number" for flight 104, departing on 7/23/2017

Display passenger name, flight number, date, seat from reservations made by Andy Anderson.

Display pilot name, number of flights as "Number of Flights", total pay as "Compensation" for flights piloted in April of 2017. Include the names of pilots who did not work in April. Order by Pilot Name

Display the names of passengers that do not have reservations. Hint a set Operation may be useful here.

Display the pilots and the number of miles flown as "Miles Flown", include pilots that have not yet flown as yet.

Display flight number, data and equipment type for all equipment that is not manufactured by BOEING. Order by departure date and flight number.

list the flights and the number of tickets sold that have an origin or destination in California

Display flight number, origination and departure for flights that originate from an airport that does not have a hub airline.

Tables and Associated Data SQL> describe ticket Name Null Type TIC ITINERARY NO NOT NULL NUMBER TIC_FLIGHT_NO TIC ELIGHT DATE NOT NULL DATE TIC SEAT SQL> select* from TICKET NOT NULL NUMBER VARCHAR2 (3) TIC ITINERARYNO TIC FLIGHT NO TIC FLIGHT DATE TIC 15 01-APR-17 329 01-APR-17 15 01-APR-17 329 10-APR-17 101 15-JUL-17 104 23-JUL-17 101 15-JUL-17 104 23-JUL-17 101 15-JUL-17 104 20-JUL-17 101 18-APR-17 104 23-JUL-17 101 18-APR-17 104 30-JUL-17 101 18-APR-17 104 23-JUL-17 606 27-APR-17 691 08-JUL-17 606 20-APR-17 606 17-MAY-17 691 19-MAY-17 102 18-APR-17 103 19-APR-17 102 18-APR-17 103 23-APR-17 10D 12D 10E 12E 3D 4D 3C 4C 3B 4B 10A 8B 10B 8C 10C 8D 12B 12A 12C 12B 13B 10B 7B 7C 3C 10 12 13 25 rows selected SOL> describe passenger Tables and Associated Data SQL> describe ticket Name Null Type TIC ITINERARY NO NOT NULL NUMBER TIC_FLIGHT_NO TIC ELIGHT DATE NOT NULL DATE TIC SEAT SQL> select* from TICKET NOT NULL NUMBER VARCHAR2 (3) TIC ITINERARYNO TIC FLIGHT NO TIC FLIGHT DATE TIC 15 01-APR-17 329 01-APR-17 15 01-APR-17 329 10-APR-17 101 15-JUL-17 104 23-JUL-17 101 15-JUL-17 104 23-JUL-17 101 15-JUL-17 104 20-JUL-17 101 18-APR-17 104 23-JUL-17 101 18-APR-17 104 30-JUL-17 101 18-APR-17 104 23-JUL-17 606 27-APR-17 691 08-JUL-17 606 20-APR-17 606 17-MAY-17 691 19-MAY-17 102 18-APR-17 103 19-APR-17 102 18-APR-17 103 23-APR-17 10D 12D 10E 12E 3D 4D 3C 4C 3B 4B 10A 8B 10B 8C 10C 8D 12B 12A 12C 12B 13B 10B 7B 7C 3C 10 12 13 25 rows selected SOL> describe passenger