Basic_SQL_Practice

Basic_SQL_Practice - report by role with crew members...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
# 1 AviaCo. Database
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
# 2 Consider 1. Show the charter trip number, date, and destination. 2. Which charters are using the aircraft 2778V? 3. What is the average hours flown by aircraft going to “ATL” – Atlanta? 4. How many flights are going to each city? 5. Which customers who went to ATL did not go to STL? 6. Which customers who went to ATL did go to STL? 7. Did any customers with an outstanding balance charter a flight on Feb. 5 or Feb. 6?
Background image of page 2
# 3 Consider 8. How much is outstanding at the company? 9. What is the average charter distance? 10.Who crewed the TYS charters? 11.What are the names of everyone involved in the TYS charters? 12.What are the names of everyone involved in the TYS charters and their role (either CREW or PASSENGER)? Arrange the
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: report by role with crew members first. # 4 Consider 13. What is the mileage charge for each flight flown after February 9? Note: Charge per mile is relative to the model; miles are an attribute of the charter. Show charter date, customer last name, charter distance, charge per mile, and mileage charge Arrange the above report so that the information displays dates in increasing fashion. Then, within dates, arrange by customer last name. 13. Produce a similar chart showing gallons per mile flown. 14. For the plane which flew the most miles, how old is its airframe, left engine, and right engine 15. For this heavily used plane, its travels in February accounted for what fraction of its airframe age?...
View Full Document

Page1 / 4

Basic_SQL_Practice - report by role with crew members...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online