ily

IDS 200 Spring 2027 Assignment 2 Duc Friday 2/24/2023 45 points Instructions Deadline In order to receive full credit, this assignment must be submitted by Friday. February 24th at 11:59pm. Submitling your assignment early is recommended. Late submissions will be acxepled flout penalized 15pts ) up to che week after the subrnission deadline. After that, assignments will not be accepted. Assignment Using the file lowgice Rate, accdp, complete the reports \& queries below. Before submitting your work, make sure your file has two reports and seven queries. 1) Reports: 1. For each Province, show the sum of Sales, grouped by ShipMode. You can include the sums using the "Summary Options" button in the third Report Wizard window, where you select ascending or descending order - choose the summary (sum) only, not summary and details, Use the Layout Vlew to expand any text boxes too small to display the Sales values - these will 2. Show the sum of Profit for each \{ProductCategory, OrderPriority\} pair. Group the records by ProductCategory, then OrderPricrity, and only show the sum of Profit, not other details. 2) Queries: 1. Show the Sales, Profit, and UnitPrice fields ionly) of all records with Sales above $10000 AND with the Shipllode being Delivery Truck. 2. Shew average Sales for each Product Category, from all records with a 2021 OrderDate. You should only have one average value per ProductCategory level. 3. Show the ID, ShipDate, and ShippingCost fields (only) of all records where the ShipDate is between 10r1/2019 and 10/31/2019 and the ProductContainer is Small Box. 4. For each Region, show the sum of Sales for each Shiphode. You should have one sum for each [Region, Shiphoted pair. 5. Show all fields of all records where the ProductCategory is Technology and the ProductContainer is Jumbo Drum. 6. For cach Region, show the sum of Sales from the months of April through October (use ShipDatc). The sum should be for the entire six-month rangc, with separate totals for cach ycar. 7. Show all fields of all records where the Shiplode is not Regular Air (in the query criteria, you can use the "o" operator for "not equal to") and the ProductContainer is Small Box or Small Pack