• 
• 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.
  1. Sales by region:
     1. Analyze sales by state to determine where the company has the largest customer base.
     2. Analyze the data to determine the top three products sold in the United States.
     3. 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
  2. Returns by region:
     1. Analyze the data to determine the top three products returned in the United States.
     2. 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 an effective summary of the analysis of the captured data.
  1. Sales by region:
     1. Provide a well-written summary of your analysis on parts A through C.
  2. Returns by region:
     1. Provide a well-written summary of your analysis on parts A and B.

• Clearly communicate your findings to the Quantigration product manager by writing a report that explains your findings in a way nontechnical stakeholders will be able to digest and use.

Reason RMAID OrderID Status Step RMA varchar(25) int int varchar(50) varchar(15) Then, the line goes to the Orders table, which has the following information: Orders int OrderID CustomerID SKU Description int varchar(20) varchar(50) Finally, the line coming out of the Orders table goes to the Customers table, which has the following information: CustomerID FirstName LastName Street City State ZipCode Telephone Customers int varchar(25) varchar(25) varchar(50) varchar(50) varchar(25) int varchar(15) Reason RMAID OrderID Status Step RMA varchar(25) int int varchar(50) varchar(15) Then, the line goes to the Orders table, which has the following information: Orders int OrderID CustomerID SKU Description int varchar(20) varchar(50) Finally, the line coming out of the Orders table goes to the Customers table, which has the following information: CustomerID FirstName LastName Street City State ZipCode Telephone Customers int varchar(25) varchar(25) varchar(50) varchar(50) varchar(25) int varchar(15)