2) Queries: On Access

1. Show the ID, OrderDate, and ShipDate fields (only) of any records where the OrderDate is between 1/1/2020 and 6/1/2020 and the ProductContainer is Wrap Bag.
2. For each Region, show the sum of Sales for each ShipMode. You should have one sum for each {Region, ShipMode} pair.
3. Show the Sales and Profit fields (only) of any records with Sales at least $500 AND the ShipMode is Express Air.
4. For each Province, show the sum of Profit from the months of July through September (use OrderDate). The sum should be for the entire three-month range, with separate totals for each year.
5. Show all fields of any records with Sales above $1200 AND the ProductCategory is Technology.
6. Show average Profit for each OrderPriority, for all records with a 2019 ShipDate. You should only have one average value per OrderPriority level.
7. Show all fields of any records where the ShipMode is Express Air and the ProductContainer is not Small Box or Small Pack (in the query criteria, you can use the <> operator for not equal to).