Project 7-2 Analyzing Databases

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by Mngene2002

7-1 Project 2 DAD 220 Gene Schexnayder 2/13/23

1. Opened up the Database with the data we need to perform our queries. Commands: mysql Then: use QuantigrationRMA; 2. Massachusetts has the most returns with 988 returns. South Carolina has the least returns with only 715 returns. There does not seem to be a trend on returns but there is an average of 851 returns across the states. States with a high return rate are states that their fleet operates more frequently or because those states have more customers. Trends could also be from factors such as the regions weather causing wear and tear. A. C ommands: Select Customers.State AS State, Count(*) AS Frequency -> From Orders Inner Join RMA On Orders.OrderID = RMA.OrderID -> Inner Join Customers On Orders.CustomerID = Customers.CustomerID -> Group BY State -> Order By Frequency DESC;

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