Query 1)

• The flight scheduling systems needs a list of drone models sorted by the fastest drone first to prioritize which drone will get assigned to a flight based on distance.
• Show the ModelID, Brand, Model, and TopSpeed
• Sort by TopSpeed

Query 2)

• What is the average salary of the remote pilots?
• Alias the result as AverageSalary

Query 3)

• Due to the safety of flying over Lake Michigan, we need to assign experienced remote pilots to those flights. Which passengers are from Michigan that will need to be reviewed before authorizing a flight?
• Show the PassID, FirstName, and LastName
• Sort by LastName then FirstName

Query 4)

• What model drones do we have that can carry packages?
• Show the ModelID, Brand, Model
• Sort by Brand then Model

Query 5)

• How many flights were scheduled in 2020?
• Alias the calculated field

Query 6)

• Of all the flights scheduled in 2020, which ones were canceled?
• Show the FlightID, TypeID, and PickUpTime
• Sort by TypeID then PickupTime

Query 7)

• On average, how close is the actual drop off time to the estimated drop off time for all flights?
• Alias the result as AvgTimeDifference