Question
Pls help me to understand these SQL command queries, thank you! 1. Copy structure and data from the ContactUpdates table in the Murach_AP database to
Pls help me to understand these SQL command queries, thank you!
1. Copy structure and data from the ContactUpdates table in the Murach_AP database to your personal database that starts with VR. Save it as ContactUpdates in the destination database too. (Hint: Use Fully qualified object name)
2.Database: AdventureWorksDW Build and test the SQL to answer this question: How many promotions have been used? Capture the screenshot of the results with SQL
3. Database: AdventureWorksDW Source: Call center facts Build and test the SQL to answer this question: Using the Call Center Facts, what is the total number of issues raised (provide suitable column headers)?
4. Database: AdventureWorksDW Source: Call center facts Build and test the SQL to answer this question: How many issues were raised by shift? (Hint: 4 rows, 2 columns)
5. Database: AdventureWorksDW Source: Call center facts Build and test the SQL to answer this question: using just the data from the AM and Midnight shifts, how many orders were placed and how many such shifts were operated during this period? (Hint: 2 rows, 3 columns)
6. Database: AdventureWorksDW Source: Call center facts Build and test the SQL to answer this question: Using data for the month of May, please produce a list showing the number of issues raised by shift type (Hint: the MONTH function may help; 4 rows 2 columns)
7. Database: AdventureWorksDW Source: Call center facts The following query can use either ROLL UP or CUBE Build and test the SQL using BOTH as two separate queries and answer this question: I need to see the average number of orders per shift along with an overall average
8. Database: AdventureWorksDW Source: Finance facts & Scenarios (You are NOT allowed to manually lookup the scenario code) Build and test the SQL to answer this question: Based on the Finance Facts, what is the total of the amount budgeted? (Hint: Use a subquery; 1 number)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started