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)