Create additional select queries for Coast Jewelers using statistics
a. Create and print a select query for Coast Jewelers that calculates the total sales value of all rings in inventory. Save this query as Ch 11 Assignment 6a before you print it.
b. Create and print a query for Coast Jewelers that includes all products and lists category name, product name, sales price, and sales value. To do this, create two computed fields: Sales Price (unit price times 1 plus the sales markup) and Sales Value (sales price time's quantity). Save this query as Ch 11 Assignment 6b before you print it.
c. Next create and print a query that sums the sales value of each category, using the query just created in assignment 6b as the source. Format this totaled value as Currency with two decimal places. Save this query as Ch 11 Assignment 6c before you print it.