Using these specific queries$-----$

Use QuantigrationRMA;

show tables;

describe Customers;

select State, COUNT$(*)$

from Customers

group by State

order by COUNT$(*)$;

SELECT SKU, COUNT$(*)$

FROM Orders

group by SKU

order by Count$(*)$ desc

LIMIT $3$;

SELECT SKU, COUNT$(*)$

FROM Orders

JOIN Customers ON Orders.CustomerID $=$ Customers.CustomerID

WHERE State IN $(\text{'}$Virginia$\text{'},$ 'North Carolina', 'South Carolina', 'Georgia'$)$

GROUP BY SKU

ORDER BY COUNT$(*)$ desc

LIMIT $3$;

SELECT SKU, COUNT$(*)$

FROM RMA

JOIN Orders on RMA.OrderID $=$ Orders.OrderID

GROUP BY SKU

ORDER BY COUNT$(*)$ DESC

LIMIT $3$;

SELECT SKU, COUNT$(*)$

FROM Orders

JOIN Customers ON Orders.CustomerID $=$ Customers.CustomerID

JOIN RMA ON Orders.OrderID $=$ RMA.OrderID

WHERE Customers.State IN $(\text{'}$Washington$\text{'},$ 'Oregon', 'Idaho', 'Montana'$)$

GROUP BY SKU

ORDER BY COUNT$(*)$ DESC

LIMIT $3$;

Do you mind helping me write a report and answer these questions?

$3.$ Write a report to the Quantigration product manager that explains your findings in a way nontechnical stakeholders can understand and use.

A$.$ Provide an effective summary of your findings from the analysis of the sales and returns data you captured. Write at least one paragraph for each of your responses to the prompts below.

i$.$ Sales data by region: Provide a well$-$written summary of findings from your analysis in Step Two, Part A$.$

ii$.$ Returns data by region: Provide a well$-$written summary of findings from your analysis in Step Two, Part B$.$ DAD $220$ Module Five Major Activity Guidelines and Rubric

Overview

In this activity, you will respond to the scenario in the prompt by capturing specific data by writing SQL commands, analyzing the data, and

summarizing your findings for a nontechnical audience. Database: QuantigrationRMA that you created in Module $3.$

Directions

Your team has been given several data sets to analyze information and summarize the findings. These data sets are in the form of simple

return merchandise authorizations $($RMAs$).$ Your task is to write short summaries of the analysis results to present to the product manager.

The product manager may or may not have a technical background. So you should write the summaries for nontechnical stakeholders.

Write a detailed summary of your analysis of the items below. Prepare your summary for nontechnical stakeholders. Use the list below to

guide the structure and organization of your report.

Specifically, you must address the following rubric criteria:

Write SQL commands that capture specific, usable data that can be used in your analysis.

Analyze the results of queries to identify specific information that can be presented in your summary.

A$.$ Sales by region:

i$.$ Analyze sales data by state to determine where the company has the largest customer base.

ii$.$ Analyze the data to determine the top three products sold in the United States.

iii. Analyze the data to determine the top three products sold in the southeastern region of the United States.

Southeastern states to include in your analysis: Virginia, North Carolina, South Carolina, and Georgia

B$.$ Returns by region:

i$.$ Analyze the data to determine the top three products returned in the United States.

ii$.$ Analyze the data to determine the top three products returned in the northwestern region of the United States.

Northwestern states to include in your analysis: Washington, Oregon, Idaho, and Montana

Write a report to the Quantigration product manager that explains your findings in a way nontechnical stakeholders can understand and

use.

A$.$ Provide an effective summary of your findings from the analysis of the sales and returns data you captured. Write at least one

paragraph for each of your responses to the prompts below in paragraph form.

i$.$ Sales data by region: Provide a well$-$written summary of findings from your analysis in Step Two, Part A$.$

ii$.$ Returns data by region: Provide a well$-$written summary of findings from your analysis in Step Two, Part B$.$

Thank you in advanced!