DAD 220 Module 7

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Industrial Engineering

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by LieutenantRock12876

DAD 220 Module 7 Athena Deutsch 1. Begin by writing SQL commands to capture usable data (which you've preloaded into Codio) for your analysis. These are the commands used to change ownership chmod +x change_perm.sh ./change_perm.sh Mysql Use QuantigrationUpdates; 2. Specifically, the product manager wants you to analyze the following: a. Analyze the number of returns by state and describe your findings in your report. SELECT Count(*) AS OVERALL_RETURNED, Orders.SKU as SKU, Customers.State, RMA.Reason FROM RMA INNER JOIN Orders ON Orders.OrderID = RMA.OrderID JOIN Customers ON Customers.CustomerID = Orders.CustomerID GROUP BY Customers.State ORDER BY OVERALL_RETURNED DESC LIMIT 10;

Based on the data returned by the QUERY I can determine that Massachusetts has the most returns per state with the quantity of returns being 988. The second and third states are closely matched with each other. They are Arkansas, which has a qty. of 858 and West Virginia which has a qty. of 851. b. Analyze the percentage of returns by product type and describe your findings in your report. SELECT Orders.SKU as SKU, Description AS Product_Description, (COUNT(*) * 100/ (SELECT COUNT(*) FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID)) AS Return_Percentage FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID GROUP BY SKU ORDER BY Return_Percentage Desc\G; Based on the records returned by the query I can determine that the three most returned products are the Basic Switch 10/100/1000 BaseT 48 port with its percentage being 22.06, the Enterprise Switch 40GigE SFP+ 48 port with its percentage being 16.28 and the Enterprise Switch 10GigE SFP+ 48 port with its percentage being 11.38.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help