Question
Employee_t Employee_ID EmployeeFirstName EmployeeLastName EmployeeJobTitle ManagerID SALES_REPRESENTATIVE_t EmployeeID(Fk) ComissionRate COURSE_t CourseID(PK) CourseDescription EMPLOYEE_COURSE_t EmployeeID(FK) CourseID(FK) CompletionDate PRODUCT_t ProductID(PK) ProductDescription StockQuantity PRICE_HISTORY_t ProductID(FK) StartDate(PK) DueDate UnitPrice
Employee_t
Employee_ID
EmployeeFirstName
EmployeeLastName
EmployeeJobTitle
ManagerID
SALES_REPRESENTATIVE_t
EmployeeID(Fk)
ComissionRate
COURSE_t
CourseID(PK)
CourseDescription
EMPLOYEE_COURSE_t
EmployeeID(FK)
CourseID(FK)
CompletionDate
PRODUCT_t
ProductID(PK)
ProductDescription
StockQuantity
PRICE_HISTORY_t
ProductID(FK)
StartDate(PK)
DueDate
UnitPrice
FABRITCATED_T
PartID(PK)
ProductID(FK)
PartQuantity
Product_Supplier_t
ProductID(FK)
SupplierID(FK)
VendorPartID
ProductCost
PurchasedQuantity
Supplier_t
SupplierID(PK)
SUpplierName
CUSTOMER_t
CustomerID (PK)
CustomerName
CustomerStreet
CUstomerState
SalesRepID
ORDER_t
OrderID(PK)
CustomerPONumber
OrderDate
DueDate
ShipDate
CustomerID(PK)
ORDER_LINE_t
OrderID(FK)
ProductID(FK)
OrderQuantity
--------------------------------------
IN SQL 2014.. Please read the questions carefully. Thank You.
-------------------------------------
1A)Which sales representative has the highest dollar amount in total sales? Hint: Provide the name and
the total sales amount for that rep only. Do not include the information for other people, and do not list details about orders. 1B)List all of the sales reps and their total commission amounts in order of highest sales commission dollar amount first. Hint: Provide all of sales reps names and their total commission dollar amounts imagine that you were going to write one check to each sales rep to pay their total commission amount, so be sure to produce that dollar amount. Extra Hint: Not all of the sales reps have sold any orders. 1C)Which sales representative has sold the most products? Hint: Name of the sales rep and a number representing the total number of distinct products sold by that rep. This is the number of different products they have sold, not the quantity of any products.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started