Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management Systems Designing And Building Business Applications

Authors: Gerald V. Post

1st Edition

0072898933, 978-0072898934

More Books

Students also viewed these Databases questions

Question

1 what does yellow colour on the map represent?

Answered: 1 week ago