MySQL Learning Team Assignment

Hello,

I am taking an Database (My SQL) class, and I need help with this assignment for week 4. I need this done by Saturday 03/18/2017

I have attached the previous weeks assignments as reference for week 4.

Week 4 Assignment

Complete work on your Learning Team Database.

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

Thanks,