Employee_t Employee_ID EmployeeFirstName EmployeeLastName EmployeeJobTitle Manag

Question

Employee_t

Employee_ID

EmployeeFirstName

EmployeeLastName

EmployeeJobTitle

ManagerID

SALES_REPRESENTATIVE_t

EmployeeID(Fk)

ComissionRate

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

Which sales representative has generated the most profit for the company? Hint: Provide the name
of the sales rep and the total profit amount only. This one SQL statement will have subqueries. You must
determine the profitability of a product by subtracting its cost from its selling price and multiplying the
difference by the quantity sold. Regarding the cost, many products are supplied by more than one
suppler, and each supplier may provide a different cost, so when this occurs, use the least expensive cost
in measuring your profitability.

Explanation / Answer

Need refereence of Sales Representive(EmployeeID) with tables Product_Supplier_t.

Without this relationship it's impossible to answer the question.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.