Write a query to produce the output

Assignment Help Management Information Sys

Reference no: EM133128347

Instructions:

Use the ‘Premiere Products Company' SQL script file found in the D2L content folder called ‘SQL Scripts'.

Paste the contents of this script into a query tab of MySQL Workbench and execute it. This will create the schema named premiere and populate it for you. After running the script, you will no longer need it.

Using MySQL SELECT commands, answer the questions listed below using the premiere schema.

Copy/paste the text from your SQL query and the output for each problem into the document and submit via the D2L drop box. Label each question with the appropriate question number.

Read each question carefully so you don't miss any steps; be sure to answer any accompanying questions for full credit.

Assignment Details:

Question 1. Using MySQL Workbench, reverse engineer the premiere schema to create the ERD. Add a text box to display your name within the ERD. Include a screenshot of your results here. This ERD is useful to help you determine which tables to use for the remainder of the assignment.

Question 2. Write a query to produce the output listed below. Only include customers that have not placed an order and sort the balance from highest to lowest. Why do you think these customers have a balance and assigned rep?

Question 3. Write a query to produce the output listed below. Order by total sale price per part in descending order.

Question 4. Write a query to produce the output listed below.

Question 5. Write a query to produce the output listed below. Hint - you will need to join three tables together and use a GROUP BY.

Question 6. Expanding on the results from Question 5, write a query to produce the output listed below. TotalSales should be based on number of units ordered and the quote price. Remove any customers without orders. Did the total number of orders change from your previous query? If so, why would the number change and which answer (Q5 or Q6) is correct?

Reference no: EM133128347

Questions Cloud

Sustaining fishing sector in the economy : As a student, what recommendations can you give to attain sustainability in the Ocean Economy?

Malaysian luxury marketing company : Watch the Netflix series "Emily in Paris" Season 2 Episode 9. Discuss the challenges that could be faced by a Malaysian luxury marketing company intending to es

Application of maslow hierarchy of needs contributes : Discuss how the application of Maslow's hierarchy of needs contributes to effective communication in a criminal justice organization.

Primary flavor and supporting flavor : Describe the difference between primary flavor and supporting flavor. Select a favorite recipe and explain the function of each ingredient

Write a query to produce the output : Write a query to produce the output listed below. Only include customers that have not placed an order and sort the balance from highest to lowest

Is conflict-of-interest a legal issue and an ethical issue : Is conflict-of-interest a legal issue, an ethical issue, or both? Provide a rationale for your opinion and support your response with at least one resource

Explain the reasoning behind any shifts in the curves : 1. Draw a supply and demand graph for the mountain bike market, which has an upward-sloping supply curve and a downward-sloping demand curve. Label the equilibr

Identify future successful companies at the startup stage : Why is it so hard to identify future successful companies at the startup stage

Wholesale market for premium scotch liquor : Based only on these data, provide quantitative estimates of the likely pre- and postmerger prices in the wholesale market for premium Scotch liquor.

User Account

All Pages