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