Use this Word document to complete the assignment. The assignment consists of a series of queries you complete using the Radix Manufacturing, Inc. Access database. For each question, create a screenshot of the SQL query and a second screenshot of the results. Paste those results into the document. The fifth question requires the query results and a written response. When you complete the assignment, upload the Word document in Blackboard. Each question is worth four points. To print screen a Windows screen, you can select the print screen button on your keyboard and paste it into Microsoft Paint or Word directly. Paint allows you to paste and then crop the picture to Word. 1. Create a query to calculate the total sales by product. Include the item ID, item description, and total sales (total_price) for the items. Use the Sales_Order_Lines and Inventory tables. 2. Create a query to calculate the total sales price for sales orders generated by the state. Round to two places. Use the Sales_Orders and Customers tables. 3. Create a query to calculate the total sales price by product. Sort the list in ascending order on the total sales price. Include the item ID, item description, and total sales dollars. Use the Sales Order_Lines and Inventory tables. [Hint: Look at number 1.] 4. Calculate the average total sales order amount for all orders. Use that amount to create a list of all orders above the average amount. Include the customer name, date, and total sales dollars. The easiest way to do this is to create two queries, one to calculate the average total sales dollars and the second to create the list. Round to two places. Use the Sales_Orders and Customers tables. 5. Use a query and determine the sales tax collected per state. Why would the sales tax be collected only in specific states? [Hint: Research nexus.] Use the Sales_Orders and Customers tables.

Use this Word document to complete the assignment. The assignment consists of a series of queries you complete using the Radix Manufacturing, Inc. Access database. For each question, create a screenshot of the SOL query and a second screenshot of the results. Paste those results into the document. The fifth question requires the query results and a written response. When you complete: the assignment, upload the Word document in Blackboard. Each question is worth four points. To print screen a Windows screen, you can select the print screen button on your keyboard and paste it into Microsoft Paint or Word directly. Paint allows you to paste and then crop the picture to Word. 1. Create a query to calculate the total sales by product. Include the item ID, item description, and total sales (total price) for the items. Use the Sales_Order_Lines and inventory tables. 2. Create a query to calculate the total sales price for sales orders generated by the state. Round to two places. Use the Sales_Orders and Customers tables. 3. Create a query to calculate the total sales price by product. Sort the list in ascending order on the total sales price. Include the item ID, item description, and total sales dollars. Use the Sales_Order_Lines and Inventory tables. [Hint: Look at number 1.] 4. Calculate the average total sales order amount for all orders. Use that amount to create a list of all orders above the average amount. Include the customer name, date, and total sales dollars. The easiest way to do this is to create two queries, one to calculate the average total sales dollars and the second to create the list. Round to two places. Use the Sales_Orders and Customers tables. 5. Use a query and determine the sales tax collected per state. Why would the sales tax be collected only in specific states? [Hint: Research nexus.] Use the Sales_Orders and Customers tables. Use this Word document to complete the assignment. The assignment consists of a series of queries you complete using the Radix Manufacturing, Inc. Access database. For each question, create a screenshot of the SOL query and a second screenshot of the results. Paste those results into the document. The fifth question requires the query results and a written response. When you complete: the assignment, upload the Word document in Blackboard. Each question is worth four points. To print screen a Windows screen, you can select the print screen button on your keyboard and paste it into Microsoft Paint or Word directly. Paint allows you to paste and then crop the picture to Word. 1. Create a query to calculate the total sales by product. Include the item ID, item description, and total sales (total price) for the items. Use the Sales_Order_Lines and inventory tables. 2. Create a query to calculate the total sales price for sales orders generated by the state. Round to two places. Use the Sales_Orders and Customers tables. 3. Create a query to calculate the total sales price by product. Sort the list in ascending order on the total sales price. Include the item ID, item description, and total sales dollars. Use the Sales_Order_Lines and Inventory tables. [Hint: Look at number 1.] 4. Calculate the average total sales order amount for all orders. Use that amount to create a list of all orders above the average amount. Include the customer name, date, and total sales dollars. The easiest way to do this is to create two queries, one to calculate the average total sales dollars and the second to create the list. Round to two places. Use the Sales_Orders and Customers tables. 5. Use a query and determine the sales tax collected per state. Why would the sales tax be collected only in specific states? [Hint: Research nexus.] Use the Sales_Orders and Customers tables