Would anyone be able to help on this assignment within a day? With some of the work done as well.Execute the following queries in the Diamond Broker database:Create an 1-page inventory list showing al

Would anyone be able to help on this assignment within a day? With some of the work done as well.

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