a) Create a query to calculate the total sales price by product. Include the item ID, inventory description, and the total sales price for the items.

b) Create a query to calculate the total sales price for sales orders generated by state. Round to two places.

c) 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.

d) 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, and the second to create the list. Round to two places.

e) Use a query and determine the sales tax collected per state. Why would the sales tax be collected in only specific states? Hint: Research nexus.

* *