Execute the following queries in the Diamond Brok

Execute the following queries in the Diamond Broker database: Create an 1-page inventory list showing all the attributes for each diamond in inventory (both in stock and not in stock) Show the total price and costs for all in stock inventory items Show a 1-page list of all diamonds that are in stock and have a carat weight of over 1.0 carats Show a 1-page list of customer names and order numbers for those customers that have placed an order in the past twelve months Show a 1-page list of all orders with customer name and include all items that are on that order