Display the different AC numbers, charter dates, and charter fuel gallons. Use the IF operator to generate fuel
replenishment status messages. Use less than 170 as your benchmark to replenish fuel and put the products in order by
AC number. It should have an appropriate column header and messages for reordering or inventory levels are fine and
sort by aircraft number and then charter fuel gallons

Answer rating: 100% (QA)

To achieve this in a MongoDB query you can use the aggregation framework along with th... View the full answer