RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
SQL Reporting
«Prev
Info Retrieval
Select Statement
What is GroupBy Clause
Group by Clause Insights
Group BY vs. Sorting
SQL Select- Quiz
SQL Subquery Statements
SQL Views
Understand SQL Views
How views are called?
Steps to Create View
Updating Table Row Views
Updating Table with View
SQL Views - Quiz
Key Sql Functions
SQL Function Overview
String | Substring Queries
Upper Lower Functions
SQL Length Function
SQL Trim Function
SQL Arithmetic Functions
SQL Sum Function
SQL Average Function
min-max Functions
SQL Date Functions
Date Function Related Issues
SQL Dateadd Function
SQL Datediff Function
SQL Datepart Function
Date Function - Exercise
Getdate | sysdate Today
SQL Function Conclusion
SQL Reporting
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?
Submit