PRODUCT 1 ProdID ProdName ProdCatID ProdPrice ORDERDETAIL 1 OrderID 1 ProdID ProdQty ProdPrice ORDER 9 OrderID OrderDate

[answerhappygod]

Product 1 Prodid Prodname Prodcatid Prodprice Orderdetail 1 Orderid 1 Prodid Prodqty Prodprice Order 9 Orderid Orderdate 1 (45.25 KiB) Viewed 27 times

List the department ID, department name, sales rep ID, first
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