# Database: Exercises: Summaries, GROUP BY

Name __________________________________________
These questions all apply to the Aviation Database.

1. How many total charter flights have been made (number of records in CHARTER)?
2. What is the average miles per gallon for all flights? You can compute the average by dividing the total distance by the total gallons.
3. What is the average miles per gallon for each aircraft (AC_NUMBER)? Use aliases to get the right column headers
4. How many trips (number of records in CHARTER) has each customer made? List the number of trips, then the customer info. Show this in order of most frequent to least frequent travelers.
5. How many times has each pilot flown each aircraft as copilot? Order by pilot's last name, then aircraft.