Create additional select queries for What SUP using statistics. (Use file you used in answering the previous question.)

a. Create and print a select query that calculates the total sales value of all Flatwater SUPs in inventory. You’ll need to use your completed query from assignment 5b as the source for this query. If you did not complete 5b, do it now. Format this computed field to Currency with two decimal places with a caption Sales Value of all Flat-water SUPs. Save this query as Ch 11 Assignment 6a before you print it.
b. Create and print a query that includes all products and lists category name, product name, unit price, unit cost, unit gross profit, quantity, and gross profit. To do this, create two computed fields: Unit Gross Profit (unit price less unit cost) and Gross Profit (unit gross profit times quantity). Both calculated fields should have a Currency for-mat and a caption with spaces. Save this query as Ch 11 Assignment 6b before you print it.
c. Next create and print a query that sums the gross profit of each category, using the query just created in assignment 6b as the source. Format this totaled value as Currency with two decimal places and a caption of Gross Profit. Save this query as Ch 11 Assignment 6c before you print it.