Instructions
This week, you learned about using database manipulation language (DML) to select records from the database. In this assignment, you will use SQL Server Management Studio Express to write SQL statements to manipulate (query) the data that is present in the database.
The following are questions that need to be answered using structured query language:
1. What is the total quantity sold for the top 5 products (based on sales)? Show only the product name, total quantity sold, and sales revenue amount in the result.
2. What is the total amount of orders for each customer? Show only the customer name and the sales revenue total in the result.
3. What is the total amount of orders associated with each product? Show only the product name and the sales revenue total in the result.
4. What is the total count of orders per month by year? Show the month, year, and the count in the result.
5. What is the total count of customers per state? Show the state (alphabetical) and the count in the result.
Part 1: SQL Script
1. Provide one SQL scriipt that includes each set of SQL statements written to answer the questions above. SELECT, JOINS, and GROUP BY aggregate functions will be required.
2. Be sure to include comments in your code that succinctly describe the logic used and also the question being answered by that section of code.
Part 2: Paper
1. Describe each question being addressed, the tables involved, and the required steps for writing a query using SQL to address the question.
2. Provide annotated screenshots of the results of each query result by embedding each in the paper.
Length: 5 to 7-page explanatory paper, plus 1 ready-to-execute SQL (.sql) file
References: None
