Assignment Overview
This assignment is composed of three parts. Be sure to complete each part to get full credit. All of your work should be uploaded on this page.
NOTE: DO NOT USE GOOGLE SHEETS FOR THIS ASSIGNMENT. YOU MUST USE EXCEL!
Part A. SQL Review (15 points) Please upload your work using the file name: A2-SQL-uniqueID.doc (or .txt or docx) to Canvas.
Part B. MS Excel Pivot Table Reveiw (15 points) Please upload your work using the file name: A2-PT-uniqueID.doc (or .txt or docx) to Canvas.
Part C. WWI – Urgent Customer Analysis (30 points) Please upload your work using the file name: A2-WWI-1-uniqueID.doc (or .txt or docx or .xls) to Canvas. 
RESOURCES:
Review of SQL: SQL-WarmUp-Tutorial.pptx
Tutorial for Pivot Tables: 
Excel_pivot_tables_tutorial.pdf
Overview of PivotTable.pdf
https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576  

https://www.sqldatadictionary.com/WideWorldImporters/