RelationalDBDesign RelationalDBDesign


SQL Reporting  «Prev 

Course Project - Exercise

Objective: Generate a report that outlines the best sales associates.
Here are the tables you have to work with for the course project. Keep in mind that some or all of these tables will be included in the solution, and that some or all of the techniques used throughout this course will be employed.

Customer

CustomerID CompanyName CompanyAddress CompanyCity CompanyState

OrderHeader

OrderID CustomerID AssociateID OrderDate

Associate

AssociateID AssociateLastName AssociateFirstName

SalesDetail

OrderID ItemID ItemQty ItemPrice ItemCost

Inventory

ItemID ItemDescription ItemQty ItemCost ItemPrice ItemVendor

What is the statement that you would use to retrieve a listing of sales by sales associate?
You only want those sales associates that have sold the product with the highest sales, based on overall quantity.
Also, what would the statement be that would create a view from that statement so you can refer to it later more easily?