PRODUCT 1 ProdID ProdName ProdCatID ProdPrice ORDERDETAIL 1 OrderID 1 ProdID ProdQty ProdPrice ORDER 9 OrderID OrderDate
Posted: Mon May 02, 2022 12:47 pm
- Product 1 Prodid Prodname Prodcatid Prodprice Orderdetail 1 Orderid 1 Prodid Prodqty Prodprice Order 9 Orderid Orderdate 1 (45.25 KiB) Viewed 29 times
name, last name, commission class, and commission rate of the sales
rep(s) who earn the highest commission in each department.
Use the following column headings: Dept_ID, Dept_Name,
Sales_Rep_ID, First_Name, Last_Name, Commission_Class,
Commission_Rate.
PRODUCT 1 ProdID ProdName ProdCatID ProdPrice ORDERDETAIL 1 OrderID 1 ProdID ProdQty ProdPrice ORDER 9 OrderID OrderDate CustID CUSTOMER CustID CustName Custl Name CustPhone SalesRepID PRODCAT 1 ProdCatID ProdCatName COMMISSION 1 CommClass CommRate SALESREP SalesRepID SalesRepFName SalesRepl.Name CommClass Deptid al DEPARTMENT Deptid DeptName