Query 1) What is the average cost per mile for each drone for all completed flights? Show
Fantastic news! We've Found the answer you've been seeking!
Question:
Query 1)
- What is the average cost per mile for each drone for all completed flights?
- Show the DroneID and AvgCostPerMile calculated field
- Sort by AvgCostPerMile
- Label the query as Query 1
Query 2)
- For demographic information, what are the top three most northern drop off location flights scheduled within our service area?
- Show all of the fields but only the top three records
- Hint: Latitude determines the North/South position
- Label the query as Query 2
Query 3)
- How many passengers are there in each state?
- Show the State and NumPassengers
- Label the query as Query 3
Query 4)
- What are the fastest speeds of all the passenger transport drones?
- List the four ModelID's and their Speeds
- Note: Passenger Transport Drones is Type ID 1
Query 5)
- How many passengers are on each flight?
- Show the FlightID and passenger count
- Sort by highest passenger count
- Label the query as Query 5
Related Book For
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese
Posted Date: