Bundor-DAD 220 Module 5-3 Major Activity Assignment

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Business

Date

Apr 25, 2024

Type

docx

Pages

5

Uploaded by DoctorHawk9805

Report
DAD 220 Module 5-3 Major Activity Assignment: Analyzing Queries C Daniel T Bundor Southern New Hampshire University DAD 220: Introduction to Structure Database Dr. Robert Rupocinski July 30, 2023
DAD 220 Module 5-3 Major Activity Assignment: Analyzing Queries 1. Write SQL commands that capture specific, usable data that can be used in your analysis. The below SQL commands will extract specific and usable data from the sales and returns data tables, providing valuable insights for the analysis of sales and returns by region. a. SELECT state, COUNT(*) AS customer_count FROM sales_data GROUP BY state ORDER BY customer_count DESC; b. SELECT product_name, SUM(quantity) AS total_sold FROM sales_data GROUP BY product_name ORDER BY total_sold DESC LIMIT 50; c. SELECT product_name, SUM(quantity) AS total_sold FROM sales_data WHERE state IN ('Virginia', 'North Carolina', 'South Carolina', 'Georgia') GROUP BY product_name ORDER BY total_sold DESC; d. SELECT product_name, COUNT(*) AS return_count
FROM returns_data GROUP BY product_name ORDER BY return_count DESC; e. SELECT product_name, COUNT(*) AS return_count FROM returns_data WHERE state IN ('Washington', 'Oregon', 'Idaho', 'Montana') GROUP BY product_name ORDER BY return_count DESC LIMIT 20; 2. 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. From the analysis of sales data by state, we found that the company has the largest customer base in California, Texas, and New York. These states contribute significantly to the overall sales volume and indicate strong market presence. ii. Analyze the data to determine the top three products sold in the United States.
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