Assignment Overview:
Using the classroom discussions last week and the knowledge you gained from last week's tutorials, list the products sold by each Salesperson during the month of January in 2012. In this assignment you will print the relevant ERD, the SQL query, and the query results to PDF files and submit the PDF files to this assignment in Blackboard. You will need the following fields for this query: Salesperson's Sales Quota, Job Title, First Name, Middle Name, Last Name, Sales Order Number, Order Date, and Product Order Quantity, and Product Name. You will need to explore the Database Diagrams to identify the six tables necessary to create this query. You will need to design and query that supplies the required information, and you will need to execute the query you created.
Instructions
1. After opening SQL Server, go to the AdventureWorks database in the left pane, expand the database, right click on database diagrams, click new database diagrams, and explore the ERD for AdventureWorks until you can identify the six tables necessary to develop the query.
2. Right click on AdventureWorks database in the left pane, click new query, then in the new blank window right click and select Design Query in Editor. When the list of tables pop's up, and select the six tables required to design the correct query.
3. Choose the fields identified in the assignment overview and modify the query to only choose data for January 2012 using a "Where" clause and with a "greater than" and "less than" sign.
4. Execute the query, fix mistakes, and repeat until you get the necessary results.
5. Print the ERD, Query, and Results each to a PDF file that you submit on Blackboard.