Question: For each query scenario in this assignment, compose a Word document that provides and explains the SQL code you have written accompanied by an Excel spreadsheet presenting the associated data. As such, you will compile and submit all three query scenario solutions into one submission, with the appropriate number of Word documents, Excel spreadsheets as needed.
Directions
Your submission will be assessed on:
- Completion of all required elements (i.e., Word document, Excel spreadsheet).
- The success of each query (i.e., how well the query works and performs as intended).
- Thoroughness of the information and data provided.
Query Scenarios
Problem One
As part of a yearly fundraising effort for the community, your manager has given you an Excel worksheet with everyone's pledged donations titled "Donations." The sheet consists of three tabs that correspond to the three months employees were asked to submit pledges. Load this file into the AdventureWorks database through the import and export wizard. Once loaded use a UNION ALL statement to combine the three data sets into a temporary table called "#TotalDonations." Compile this task as per the assignment requirements.
Problem Two
Redoing the UNION ALL statement you created in Problem One, a temporary table should be created, looking exclusively at SUM of Donations by Month. Title each of the three fields "Donations and Month" with the temporary table titled "#DonationsbyMonth." When complete, provide also the total of the final amount of donations raised. Compile this task as per the assignment requirements.
Problem Three
Your manager e-mails you about the final results you provided in Problem Three, and believes you must have made a mistake when calculating the total donations. The amount is $100 shy of the total amount by the manager's calculations. The manager thinks it is possible that one employee might have accidently pledged $100 twice. Explain how this event might occur with a UNION ALL and, if so, rewrite the first query with a UNION statement. Is your manager's assumption correct?
General Requirements
Compile the Word, Excel documents into one document to submit