Select Page

Use SQL Server Management Studio Express to write SQL statements to manipulate (query) the data that is present in the database.

by | Apr 11, 2022 | Other | 0 comments

For This or a Similar Paper Click To Order Now

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

 

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Our confidential essay writing service protects your privacy

We cherish your trust and do our best to protect you. Anything that you share with our private essay writing service is never misused as the access to your personal data is very limited. Your payment details and credit card number also fall under strict protection when you buy a custom essay online from us.