Answered You can hire a professional tutor to get the answer.
Hello, I am having a lot of trouble with Queries. I am not where to even Start a query. I have built tables and EER Diagram in MySQL already.
Hello,
I am having a lot of trouble with Queries. I am not where to even Start a query. Can someone help me with this question below. I have built tables and EER Diagram in MySQL already. Where do I write the queries and how do I execute them?
Perform the following queries in the Diamond Broker database:
- Build a one 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 one page list of all diamonds that are in stock and have a carat weight of over 1.0 carats
- Show a one page list of customer names and order numbers for those customers that have placed an order in the past twelve months
- Show a one page list of all orders with customer name and include all items that are on that order
Compress the output of the queries including all of the scripts to create the database tables, to establish keys and constraints, to populate data within the database, and queries into a single ZIP folder.
I do not have the option to attach my SQL Database to this, so if someone can help. I can share my SQL table.
