Question: SQL Questions 1. Display all the information in the flight table 2. How many reservations were made on Jan 07-2016 3. What is the total


SQL Questions 1. Display all the information in the flight table 2. How many reservations were made on Jan 07-2016 3. What is the total amount of f ares passengers paid for flights between Jan-01-2016 and Feb-01-2016 4 Who is the highest paid pilot on a per flight basis? (may use a sub queryi 5. Provide me a list of al 6. What is 7. Which flights are piloted by pilots from Texas? 8. Which flights have the smallest number of seats? Il the pilots' names in sorted in ascending order without duplicates the address of the pilots bor n in Jan? (assume date format is Jan-07-2000 and is text) How many ticketed passengers are on each flight with passengers? 0. List passenger, names for each flight sort by flightnumber then passenger name. 9. SQL Questions 1. Display all the information in the flight table 2. How many reservations were made on Jan 07-2016 3. What is the total amount of f ares passengers paid for flights between Jan-01-2016 and Feb-01-2016 4 Who is the highest paid pilot on a per flight basis? (may use a sub queryi 5. Provide me a list of al 6. What is 7. Which flights are piloted by pilots from Texas? 8. Which flights have the smallest number of seats? Il the pilots' names in sorted in ascending order without duplicates the address of the pilots bor n in Jan? (assume date format is Jan-07-2000 and is text) How many ticketed passengers are on each flight with passengers? 0. List passenger, names for each flight sort by flightnumber then passenger name. 9
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
