Query $5)$

Drone technology and efficiency should be improving over time, the team is expecting to see an increase in flights with a decrease in average duration. Create a query that shows the average flight duration $($in minutes$)$ of completed flights for each year, along with the number of flights, to see if the newer drones and upgraded technology is improving delivery times.

Note: The current year may show fewer flights as many are not completed yet or scheduled through the end of the year.

Show the fields displayed in the example below.

Sort by Year

Label the query as Query $5$

Example Results:

$\backslash$table$[[$Year$,$NumFlights,AvgDuration$],[2020,14,178\mathrm{.}29],[2021,504,145\mathrm{.}22],[2022,608,125\mathrm{.}07],[2023,140,120\mathrm{.}90]]$